You might be able to use an IN block. If I understand what you're saying, you're looking for middle managers who report to another manager.
Have you looking into something like:
This will select all managers who have a supervisor_id in that same table, managers.
w3schools SQL IN tutorial