0 - 1 of 1 tags for heirarchal

I have a table that is a list of users that I need get as a heirachal answer set. This table has people from 1st level, 2nd level, and 3rd level in the organizations heirarchy all built the same way..i.e.

user_id first_name last_name supervisor_id

My problem is that supervisors are built the same way, where the supervisor_id is actually a 2nd line manager. What I need to do is retrieve users by specifying the 3rd level (second line manager) , and list it as such:

user_id first_name last_name supervisor_id second_line_manager