SELECT
  s.fio as sotrudnik_id,
  m.fio as manager_id
FROM Sotrudniki s
LEFT JOIN Sotrudniki m
  ON s.id_manager = m.id
ORDER BY s.fio;

SELECT
  s1.fio,
  s2.fio
FROM Sotrudniki s1
JOIN Sotrudniki s2
  ON s1.id_manager = s2.id;

select distinct s.fio, m.fio
from sotrudniki s inner join sotrudniki m on s.id_manager = m.id
order by m.id