SELECT e.employee_id,e.last_name,m.manager_id,m.last_name FROM employees AS e,employees AS m WHERE m.employee_id=e.manager_id
mysql 自连接
原文：https://blog.51cto.com/14437184/2437292
