The code below might help get the list of up level managers. I'm not sure how to easily get the list of employees each person manages...

WITH...