1.雇员表内的reporter列,CEO的汇报对象为空,连接时不想删除CEO信息SELECT *FROM employees eLEFT JOIN employees mON e.employee_id = m.employee_id