create table part_list
(
  part     varchar(32),
  sub_part varchar(32),
  quantity int
);

insert into part_list values
('Bicycle', 'Wheel', 1),
('Bicycle', 'Wheel', 1),
('Bicycle', 'Frame', 1),
('Bicycle', 'Pedal', 2),

('Wheel', 'Spokes', 32),
('Wheel', 'Rim', 1),
('Wheel', 'Tube', 1),

('Frame', 'Fork', 1),
('Frame', 'Seat post', 1),
('Frame', 'Saddle', 1),
('Frame', 'Handlebar', 1);


with recursive P as (
  select part, sub_part, quantity
  from part_list
  where part='Bicycle'

  union all

  select part_list.part, part_list.sub_part, part_list.quantity
  from P, part_list
  where
    P.sub_part = part_list.part
)
select * from P;