MYSQL递归查询语句(亲测可用)

常用于子父级递归查询

WITH RECURSIVE _parent AS
(
 SELECT t.* FROM `表1` t WHERE t.id='参数' 
    UNION ALL
 SELECT t.*  FROM _parent,`表1` t WHERE t.id=_parent.pid

)
SELECT * FROM _parent;

ps:

楼主使用mysql版本8.0

WITH RECURSIVE 将查询结果带入下次查询，进行递归，查询全路径