单纯MYSQL递归查询上下级关系

查询 id = 6 的所有父级

SELECT ID.level, DATA.* FROM( 
SELECT 
@id as _id, 
( SELECT @id := parent_id 
FROM table1 
WHERE id = @id 
) as _pid, 
@l := @l+1 as level 
FROM table1, 
(SELECT @id := 6, @l := 0 ) b 
WHERE @id > 0 
) ID, table1 DATA 
WHERE ID._id = DATA.id 
ORDER BY level;SELECT ID.level, DATA.* FROM(