select
a.id,a.name,a.father_id,
case when a.father_id is null then a.id else b.id end,
case when a.father_id is null then a.name else b.name end,
case when a.father_id is null then a.father_id else b.father_id end
from tb a
left join tb b on a.father_id=b.id
order by a.id