SELECT a.* from
(
SELECT DATA.code FROM(
SELECT
@ids AS _ids,
(
SELECT @ids := GROUP_CONCAT(code)
FROM bpm_sys_permission
WHERE FIND_IN_SET(parent_id, @ids)
) AS cids,
@l := @l+1 AS level
FROM bpm_sys_permission, (SELECT @ids := (#{permissionCode}) , @l := 0 ) b
WHERE @ids IS NOT NULL
) ID, bpm_sys_permission DATA
WHERE FIND_IN_SET(DATA.code, ID._ids)
ORDER BY level,code
) as a
关于通过MYSQL 查询父亲下面所有子节点
最新推荐文章于 2024-06-04 17:57:46 发布