sql 递归查询

sql 递归查询

with my1 as(

select  * from JTZK_Comment where Status=1 
 union all 
select JTZK_Comment.* from my1,JTZK_Comment where my1.ParentId = JTZK_Comment.id
)
select  DISTINCT * from my1;