MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table Employees (
  Employee varchar(1),
  Manager varchar(1)
);
insert into Employees values
('A', 'B'),
('B', 'C'),
('C', 'F'),
('F', 'R'),
('R', 'I'),
('G', 'B'),
('H', 'B'),
('I', 'I')

Records: 8  Duplicates: 0  Warnings: 0


select e.Employee
       , e.Manager  as Manager_1
       , e2.Manager as Manager_2
       , e3.Manager as Manager_3
       , e4.Manager as Manager_4
       , e5.Manager as Manager_5
from Employees e
inner join Employees e2 on e2.Employee = e.Manager
inner join Employees e3 on e3.Employee = e2.Manager
inner join Employees e4 on e4.Employee = e3.Manager
inner join Employees e5 on e5.Employee = e4.Manager;


Employee
Manager_1
Manager_2
Manager_3
Manager_4
Manager_5


A
B
C
F
R
I

G
B
C
F
R
I

H
B
C
F
R
I

C
F
R
I
I
I

R
I
I
I
I
I

I
I
I
I
I
I

F
R
I
I
I
I

B
C
F
R
I
I