SQL Server 2005 CTEµÄÓ÷¨

if object_id('[tb]') is not null
drop table [tb] 
go
create table [tb]([id] int,[col1] varchar(8),[col2] int) 
insert [tb] 
select 1,'ºÓ±±Ê¡',0 union all
 select 2,'ÐĮ̈ÊÐ',1 union all
 select 3,'ʯ¼ÒׯÊÐ',1 union all
 select 4,'ÕżҿÚÊÐ',1 union all
 select 5,'ÄϹ¬',2 union all 
select 6,'°ÓÉÏ',4 union all
  select 7,'ÈÎÏØ',2 union all
 select 8,'ÇåºÓ',2 union all 
select 9,'ºÓÄÏÊ¡',0 union all
 select 10,'ÐÂÏçÊÐ',9 union all
 select 11,'aaa',10 union all
 select 12,'bbb',10  
 
 ;with t as( 
select * from [tb] where col1='ºÓ±±Ê¡'  union all  select a.* from [tb] a  ,t where a.col2=t.id   
)
 
 select * from t