mysql递归

前段时间做了个功能，需要根据父级查询子级，开始是用程序写的，后来嫌麻烦就打算用sql来写，代码如下

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 := '条件id', @l := 0 ) b 
        WHERE
                @ids IS NOT NULL 
        ) ID,
        表名 DATA 
WHERE
        FIND_IN_SET( DATA.id, ID._ids ) 
ORDER BY
        LEVEL,
        id