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

Question

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 != ''

 

这个sql在执行的时候会出现 返回多行的错误，，网上很多帖子mysql根据子节点查询父节点都是这样写的。。哪个大神能指导一下

Answer 1

楼主解决了没?