WITH RECURSIVE tmp AS
(
WITH fruit AS
(
SELECT 'FRUIT_1000' fruit_id, '자두' fruit_name, NULL parent_fruit_id
UNION ALL SELECT 'FRUIT_1100', '키위', 'FRUIT_1000'
UNION ALL SELECT 'FRUIT_1101', '포도', 'FRUIT_1100'
UNION ALL SELECT 'FRUIT_1103', '사과', 'FRUIT_1100'
UNION ALL SELECT 'FRUIT_2000', '배'  , NULL
UNION ALL SELECT 'FRUIT_2100', '딸기', 'FRUIT_2000'
UNION ALL SELECT 'FRUIT_2101', '수박', 'FRUIT_2100'
)
SELECT fruit_id, fruit_name, parent_fruit_id
     , fruit_name root_name
  FROM fruit
 WHERE parent_fruit_id IS NULL
 UNION ALL
SELECT c.fruit_id, c.fruit_name, c.parent_fruit_id
     , p.root_name
  FROM tmp p
 INNER JOIN fruit c
    ON p.fruit_id = c.parent_fruit_id
)
SELECT *
  FROM tmp
;