Query to find User's Manager's Manager

[RV]

I am looking for a Query to fetch username and their immediate manager and manager's manager.  Can you please help me with the query ?

[rushikeshvartak · Accepted solution]

select u.username user ,m.username mgr ,mm.username mgr_mgr from users u left join users m on u.manager=m.userkey left join users mm on m.manager=mm.userkey