MySQL 8.0

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

CREATE TABLE nodes
(
    UUID VARCHAR(50) NOT NULL, 
    PARENT_UUID VARCHAR(50) NULL,
    NAME VARCHAR(20) NOT NULL, 
    PRIMARY KEY (UUID)
);
INSERT INTO nodes (uuid, parent_uuid, name)
VALUES 
('dfca05bc-551d-4e3d-87aa-7dd7d29539f6', null, 'Computers'),
('ff83eb99-ea2c-4d11-8ebe-4600445a3bda', null, 'Food'),
('405f0267-fa22-4cac-a397-c430be221828', null, 'Drinks'),
('e79ecefa-c3e2-400f-aab4-2d28fcd3a832', 'dfca05bc-551d-4e3d-87aa-7dd7d29539f6', 'Monitors'),
('61a94b77-56c2-48ff-b869-39305648a25c', 'dfca05bc-551d-4e3d-87aa-7dd7d29539f6', 'System blocks'),
('5d88a9b7-7ffe-45e5-b35f-9350072ed619', 'dfca05bc-551d-4e3d-87aa-7dd7d29539f6', 'Mother boards'),
('5994c39d-c4ea-454c-ae57-118392b93f66', 'dfca05bc-551d-4e3d-87aa-7dd7d29539f6', 'Different'),
('d1c994fe-f3ec-40ed-aace-5221c026c0ea', '5994c39d-c4ea-454c-ae57-118392b93f66', 'Keyboards'),
('7757aa9b-abee-4d30-89d3-79f77613b5e8', '5994c39d-c4ea-454c-ae57-118392b93f66', 'Mice'),
('33d93c3a-1c2d-44b9-8fac-3f83074104a5', '5994c39d-c4ea-454c-ae57-118392b93f66', 'Joysticks'),
('f13bb023-47b2-473a-83b0-4223ff6e28b9', 'e79ecefa-c3e2-400f-aab4-2d28fcd3a832', 'Size 14'),
('312a4e56-71ef-4372-a556-17ace15197e6', 'e79ecefa-c3e2-400f-aab4-2d28fcd3a832', 'Size 15'),
('c525374c-6a06-46e4-98c8-bc669e811e22', 'e79ecefa-c3e2-400f-aab4-2d28fcd3a832', 'Size 16');

Records: 13  Duplicates: 0  Warnings: 0


-- order by names
WITH RECURSIVE tree (uuid, parent_uuid, name, level, path) AS 
(
    SELECT uuid, parent_uuid, name, 0 level, cast(Rpad(name, 20, ' ') as char(200)) path
    FROM nodes 
    WHERE uuid = '33d93c3a-1c2d-44b9-8fac-3f83074104a5'

    UNION ALL

    SELECT a.uuid, a.parent_uuid, a.name, level-1,  concat(Rpad(a.name, 20, ' '),'>', path)
    FROM nodes a
    INNER JOIN tree b ON b.parent_uuid = a.uuid
)
select uuid, name, level /*, path */
from (
   select n.uuid, n.name
      , max(-level) over() + level + 1  level
      , concat(substring(first_value(path) over(order by level), 1, (20+1) * (max(-level) over() + level +1 )), n.name) path
   from tree t
   join nodes n on n.parent_uuid = t.uuid 
       -- no children for starting node
       and t.level <> 0
   
   union all
   --  roots
   select uuid, name, 0, Rpad(name, 20, ' ')
   from nodes
   where parent_uuid is null 
) t
order by path


uuid
name
level


dfca05bc-551d-4e3d-87aa-7dd7d29539f6
Computers
0

5994c39d-c4ea-454c-ae57-118392b93f66
Different
1

33d93c3a-1c2d-44b9-8fac-3f83074104a5
Joysticks
2

d1c994fe-f3ec-40ed-aace-5221c026c0ea
Keyboards
2

7757aa9b-abee-4d30-89d3-79f77613b5e8
Mice
2

e79ecefa-c3e2-400f-aab4-2d28fcd3a832
Monitors
1

5d88a9b7-7ffe-45e5-b35f-9350072ed619
Mother boards
1

61a94b77-56c2-48ff-b869-39305648a25c
System blocks
1

405f0267-fa22-4cac-a397-c430be221828
Drinks
0

ff83eb99-ea2c-4d11-8ebe-4600445a3bda
Food
0

uuid	name	level
dfca05bc-551d-4e3d-87aa-7dd7d29539f6	Computers	0
5994c39d-c4ea-454c-ae57-118392b93f66	Different	1
33d93c3a-1c2d-44b9-8fac-3f83074104a5	Joysticks	2
d1c994fe-f3ec-40ed-aace-5221c026c0ea	Keyboards	2
7757aa9b-abee-4d30-89d3-79f77613b5e8	Mice	2
e79ecefa-c3e2-400f-aab4-2d28fcd3a832	Monitors	1
5d88a9b7-7ffe-45e5-b35f-9350072ed619	Mother boards	1
61a94b77-56c2-48ff-b869-39305648a25c	System blocks	1
405f0267-fa22-4cac-a397-c430be221828	Drinks	0
ff83eb99-ea2c-4d11-8ebe-4600445a3bda	Food	0