How to get Employees Hierarchy

Question

Hi,

My requirement is as follows: I would like to obtain Employee Wise Hierarchy (Bottom Employees to Top Employees) using SP.

Note (Role): NH is Level-1(Top Level) VH is Level-2 AVP is Level-3 RM is Level-4 DRM is Level-5 BM is Level-6 TH is Level-7 FLS (Bottom Level)

My Table:

My table contain All employees ID, all employees name, designation, along with their manager name and manager id

this is the reference image which i used in SQL As well as in power bi but i did'nt get the answer please suggest

OUTPUT should be like this

NOTE( if the BM reports BM so we need to move BM2 in next column And this stituation is same as in TH )