MYSQL根据id递归向下查询所有子级

SELECT
    ID.LEVEL,
    DATA.*
FROM
    (
SELECT
    @ids AS _ids,
    ( SELECT @ids := GROUP_CONCAT( id ) FROM 表名  WHERE FIND_IN_SET( 父级id字段, @ids ) ) AS cids,
    @l := @l + 1 AS LEVEL 
FROM
    表名,
    ( SELECT @ids :=30, @l := 0 ) b 
WHERE
    @ids IS NOT NULL 
    ) ID,
    表名 DATA 
WHERE
    FIND_IN_SET( DATA.id, ID._ids ) 
ORDER BY
    LEVEL,
    id