MySQL查询自己创建的用户以及子用户创建的所有用户

	SELECT
    u2.id,
    u2. username
FROM
    (
        SELECT
            @ids AS p_ids,
            (
                SELECT
                    @ids := GROUP_CONCAT(id)
                FROM
                    sys_user
                WHERE
                    FIND_IN_SET(create_id, @ids)
            ) AS c_ids ,@l := @l + 1 AS LEVEL
        FROM
            sys_user,
            (SELECT @ids := '1', @l := 0) b
        WHERE
            @ids IS NOT NULL
    ) u1
JOIN sys_user u2 ON FIND_IN_SET(u2.id, u1.p_ids)
AND u2.id != '1'