sqlserver递归查询

 --递归查询
 with cte as
 (
 select a.ID,a.Text, a.Name,a.PID from Menu a where id=''
 union all
 select k.id,k.Text, k.name,k.pid  from Menu k inner join cte c on c.id = k.pid
 )select * from cte