SELECT
ID.LEVEL,
DATA.*
FROM
(
SELECT
@ids AS _ids,
( SELECT @ids := GROUP_CONCAT( ID ) FROM res_area WHERE FIND_IN_SET(I_PARENT_ID, @ids ) ) AS cids,
@l := @l + 1 AS LEVEL
FROM
res_area,
( SELECT @ids := 441000000000007995124440, @l := 0 ) b
WHERE
@ids IS NOT NULL
) ID,
res_area DATA
WHERE
FIND_IN_SET( DATA.ID, ID._ids )
ORDER BY
LEVEL
用于记录笔记,但是性能方面可能存在问题。