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 base_authority_organization t ORDER BY parent_id, id ) t1,
( SELECT @pids := '3209HZB' ) t2
) t3
WHERE
ischild != 0;
仅根据id和parent_id