SO48874377, MySQL - rextester

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

drop table if exists SO48874377;

Create table SO48874377  (
    employee varchar(50),
    manager varchar(50));
    
Insert into SO48874377 (employee, manager) values

('Bryce Posada',        'Antony Real'),  
('Sung Hosey',          'Aurelio Havlik'),  
('Joan Strother',       'Aurelio Havlik'),  
('Irwin Fulks',         'Barton Rose'),  
('Rocco Keplin',        'Benito Cowboy'),  
('Efrain Ricketson',    'Benito Cowboy'),  
('Patricia Hackenberg', 'Benito Cowboy'),  
('Paris Sigala',        'Chuck Lawson'),  
('Alva Kaul',           'Ernest Divens'),  
('Eli Bielecki',        'Ernest Divens'),  
('Walton Virden',       'Ernest Divens'),  
('Raphael Montesino',   'Ernest Divens'),  
('Dewayne Biggs',       'Lonny Meller'),  
('Josef Bakken',        'Marc Margulies'),  
('Everett Gresham',     'Marc Margulies'),  
('Zachariah Yochum',    'Otto Brannum');

SELECT Der_tab_Col1.employee, Der_tab_Col2.employee, Der_tab_Col1.manager, Der_tab_Col1.RN table_1RN, Der_tab_Col2.RN table2_RN
FROM (SELECT A.Employee, case when @MGR <> A.Manager THEN @RN:=0 end as resetRN, @RN:=@RN+1  RN, @MGR:=A.Manager as Manager
      FROM SO48874377 A
      cross join (Select @RN:=0, @MGR:='') Z
      Order by manager, employee) Der_tab_Col1
LEFT JOIN (SELECT A.Employee, case when @MGR2 <> A.Manager THEN @RN2:=0 end as resetRN, @RN2:=@RN2+1  RN, @MGR2:=A.Manager as Manager
      FROM SO48874377 A
      cross join (Select @RN2:=0, @MGR2:='') Z
      Order by manager, employee) Der_Tab_col2
   on Der_tab_Col1.Manager = Der_tab_Col2.Manager
  and Der_tab_Col1.RN+1 = Der_tab_Col2.RN
WHERE mod(der_tab_col1.rn,2)=1
ORDER BY der_tab_col1.manager, Der_tab_Col1.RN;

drop table if exists SO48874377;


absolute service time: 0,34 sec