As I understand your question

SELECT SupervisorFirstName = e1.firstname,

SupervisorLastName = e1.lastname,

EmployeeFirstName = e2.firstname,

EmployeeLastName = e2.lastname

FROM dbo.staffhierarchy h,

dbo.employee e1,

dbo.employee e2

WHERE h.supervisorid = e1.id

AND h.employeeid = e2.id

AND h.managerid = 1

CEWII