记一次SQL递归查询所有子级（不包括本身）

SELECT * FROM
(
SELECT * FROM basis_pbom where parent_id > 0 ORDER BY parent_id, id DESC
) realname_sorted,
(SELECT @pv := 父级id
) initialisation
WHERE (FIND_IN_SET(parent_id,@pv)>0 And @pv := concat(@pv, ‘,’, id))