mysql根据子节点查询所有父节点(不用函数或过程)
SELECT T1.id,T1.`name`,T1.pid,T2.sort
FROM tbl_lanmu T1
INNER JOIN (
SELECT
@id AS _id,
(SELECT @id := pid FROM tbl_lanmu WHERE id = _id) AS pid,
@sort := @sort + 1 AS sort
FROM
(SELECT @id := 'cd4cf93b-95d4-40a8-bb25-7102c08988b1',@sort := 0) T2_1,tbl_lanmu T2_2
WHERE
@id IS NOT NULL and @id != ''
) T2 ON T1.id = T2._id
ORDER BY T2.sort DESC;