mysql递归查询子集

SELECT
            *
            FROM(
            SELECT
            @ids AS _ids,
            ( SELECT @ids := GROUP_CONCAT(id)
            FROM t_office
            WHERE FIND_IN_SET(parent_id, @ids)
            ) AS cids,
            @l := @l+1 AS LEVEL
            FROM t_office,
            (SELECT @ids :=#{要查询子集的数据库字段id}, @l := 0 ) b
            WHERE @ids IS NOT NULL
            ) id, t_office DATA
            WHERE FIND_IN_SET(DATA.id, ID._ids)
            ORDER BY LEVEL, id