mysql 树表查询祖级id（父级父级父级....）

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才能用，项目需要不让换）