您已经错过了订购数据的需要。请尝试以下操作:SQL Fiddle
select t.nodeid, @pv := t.parentid parentid
from (select * from table1 order by nodeid desc) t
join (select @pv := 8) tmp
where t.nodeid = @pv
输出:
| NODEID | PARENTID |
|--------|----------|
| 8 | 6 |
| 6 | 5 |
| 5 | 3 |
| 3 | 0 |