MYSQL 向上递归查询

MYSQL 向上递归查询

SELECT T2.`COURSE_LIST_ID`,T2.`COURSE_LIST_NAME`
FROM ( 
    SELECT 
        @r AS _id, 
        (SELECT @r := PARENT_ID FROM edu_course_list WHERE COURSE_LIST_ID = _id) AS PARENT_ID, 
        @l := @l + 1 AS lvl 
    FROM 
        (SELECT @r := "000000006587ceee0165885534b7038a", @l := "0") vars, 
         edu_course_list  h 
    WHERE @r <> "0") T1 
LEFT JOIN edu_course_list T2 
ON T1._id = T2.COURSE_LIST_ID 
WHERE T2.`PARENT_ID` IS NULL
ORDER BY T1.lvl DESC