SELECT a.id,a.reid,a.topid,concat(a.name,b.name,b1.name) as fullname from tt a left join tt b on a.topid=b.id left join tt b1 on a.reid=b1.id where a.topid>=1 and a.reid>1 and b.reid=0 and b.topid=0 and b1.reid=1 and b1.topid=1
select a.id,a.reid,a.topid,concat(c.name,b.name,a.name) from table1 a,table1 b,table1 c where a.reid=b.id and b.reid=c.id
from tt a left join tt b on a.topid=b.id
left join tt b1 on a.reid=b1.id
where a.topid>=1 and a.reid>1 and b.reid=0 and b.topid=0 and b1.reid=1 and b1.topid=1
from table1 a,table1 b,table1 c
where a.reid=b.id and b.reid=c.id