SQL 语句:
SELECT *
FROM `表名`
WHERE id IN(
SELECT id
FROM(
SELECT id, pid
FROM `表名`
WHERE pid> 0 ORDER BY pid, id DESC
) t1,(
SELECT @pv := 根节点ID
) t2
WHERE (FIND_IN_SET(pid,@pv)>0 AND @pv := CONCAT(@pv, ',', id))
)
示例: