CTE是Mysql8.0开始支持

这里是一个例子表，此处示例需要拿到 ID 为 102 下的所有子集

这里是sql语句

WITH RECURSIVE cte AS (
SELECTID,PID,NAME,LEVEL,Type 
FROMtmp_zjs 
WHEREID = '102' 
UNION ALL
SELECTsou.ID,sou.PID,sou.NAME,sou.LEVEL,sou.Type 
FROMcte cINNER JOIN tmp_zjs sou ON c.ID = sou.PID 
) 
SELECT * FROM	cte

得到的结果是