mysql根据节点查找所有叶节点

部分转载至
SELECT
u2.*
FROM
(
SELECT
@ids AS p_ids,
( SELECT @ids := GROUP_CONCAT( id ) FROM oa_department WHERE FIND_IN_SET( pid, @ids ) ) AS c_ids,
@l := @l + 1 AS LEVEL
FROM
oa_department,
( SELECT @ids := ‘10’, @l := 0 ) b
WHERE
@ids IS NOT NULL
) u1
JOIN oa_department u2 ON FIND_IN_SET( u2.id, u1.p_ids )
AND u2.id != ‘10’;

本作品采用《CC 协议》，转载必须注明作者和本文链接