mysql - 数据库查询一条复杂的select语句

Question

我有一个表，里面有 id name 和 manager id

id  name  manager_id
1  myName  4
2  alex    3
3  brain   2
4  someone 1

现在我必须编写显示结果的查询

myname someone
alex brain
brain alex
someone myname

意思是我们要根据Id显示name和manager Name

Answer 1

用自己连接表:

SELECT t1.name, t2.name FROM my_table AS t1 
    LEFT JOIN my_table AS t2 ON( t1.manager_id = t2.id )