SELECT
t2.*
FROM
(
SELECT
@r AS _id,
( SELECT @r := parent_id FROM book_menu WHERE menu_id = _id ) AS parent_id,
@s := @s + 1 AS sort
FROM
( SELECT @r := 9, @s := 0 ) temp,
book_menu
WHERE
@r > 0
) t1
JOIN book_menu t2 ON t1._id = t2.menu_id
book_menu 表
menu_id 主键
parent_id 父级主键
mysql5.7可用(找了个递归函数的deimysql8.0才能用,项目需要不让换)