WITH recursive cte(n) as(select 1 UNION all SELECT n+1 from cte where n<20) SELECT * from cte; 

recursive 定义递归调用

WITH dt as (select * from `user`) SELECT * from dt: with关键字定义变量