SQLize Online / PHPize Online  /  SQLtest Online

create table person( id int auto_increment, name varchar(100), manager_id int, primary key (id) ); insert into person (name, manager_id) values('Vasya', null), ('Petya', 1), ('Kostya', 2), ('Serega', 3), ('Sanya', null); with recursive person_tree(id, name, manager_path) as( select id, name, cast(id as char(200)) from person where manager_id is null union all select s.id, s.name, concat(m.manager_path, ",", s.id) from person_tree m join person s on m.id=s.manager_id ) select * from person_tree order by manager_path;