通过sql实现传入父级id查询出所有的子集

通过sql实现传入父级id查询出所有的子集

SELECT
        t3.*
    FROM (
        SELECT
            t1.*,
            t2.*,
            IF(FIND_IN_SET(parent_id, @pids) > 0, @pids := CONCAT(@pids, ',', id), '0') AS isChild
        FROM (
            SELECT * FROM rule_entity_property WHERE gmt_status != '-1' ORDER BY name,parent_id,id
        ) AS t1,
        ( SELECT @pids := 这里是传进来的顶级id ) AS t2
    ) t3
    WHERE t3.isChild != '0'