查询id为1408348744236806146下的所有子孙节点的id
SELECT
id
FROM
(SELECT
t1.id,
IF (
FIND_IN_SET(parent_id, @pids) > 0,
@pids := CONCAT(@pids, ',', id),
0
) AS ischild
FROM
(SELECT
id,
parent_id
FROM
party_sys_organization t
WHERE t.del_flag = 0
ORDER BY parent_id,
id) t1,
(SELECT
@pids := 1408348744236806146) t2) t3
WHERE ischild != 0 ;