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'
MySQL查询自己创建的用户以及子用户创建的所有用户
最新推荐文章于 2024-04-22 20:02:08 发布