Employee (ID, Name, ManagerID)
Manager (ID, Name)

SELECT * from Employee e
LEFT JOIN Manager m ON e.ManagerID = m.ID;