MySQL 查找所有子节点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 dept t WHERE t.state = 0 ORDER BY parent_id, id
            ) t1,
            (SELECT @pids := #{deptId}) t2
            ) t3 WHERE ischild != 0