mysql根据子节点查询所有父节点（不用函数或过程）

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;