递归查询sql 记录

SELECT
ID.LEVEL,
DATA.*
FROM
(
SELECT
@ids AS _ids,
( SELECT @ids := GROUP_CONCAT( defect_id ) FROM t_defect_classification WHERE FIND_IN_SET( p_defect_id, @ids ) ) AS cids,
@l := @l + 1 AS LEVEL
FROM
t_defect_classification,
( SELECT @ids := ‘493416568936488960’, @l := 0 ) b
WHERE
@ids IS NOT NULL
) ID,
t_defect_classification DATA
WHERE
FIND_IN_SET( DATA.defect_id, ID._ids )
ORDER BY
LEVEL,
defect_id