SELECT T2.level_, T3.*
FROM(
SELECT @ids as _ids,
( SELECT @ids := GROUP_CONCAT(id)
FROM tb_organization_manual
WHERE FIND_IN_SET(parent_id, @ids)
) as T1,
@l := @l+1 as level_
FROM tb_organization_manual,
(SELECT @ids := #{orgId}, @l := -1 ) T4
WHERE @ids IS NOT NULL
) T2, tb_organization_manual T3
WHERE FIND_IN_SET(T3.id, T2._ids)
AND T3.delete_status = 0
ORDER BY level_, id
查询组织树Sql 项目实测
于 2022-11-16 21:53:53 首次发布