oracle自连接查询

select a.id, a.name from test a, test b
where a.id = b.manager