manager

SELECT
e.employee_id,
e.first_name,
m.employee_id AS manager_id,
m.first_name AS manager_name
    FROM employees AS e
        JOIN employees AS m
            ON m.employee_id = e.manager_id
        WHERE e.manager_id IN (3,7)
    ORDER BY e.employee_id