with a as(
select 1 id , 'A' product, 0 depth union all
select 2 id , 'B' product, 1 depth union all
select 3 id , 'C' product, 2 depth union all
select 4 id , 'D' product, 2 depth union all
select 5 id , 'E' product, 2 depth union all
select 6 id , 'F' product, 1 depth union all
select 7 id , 'G' product, 2 depth union all
select 8 id , 'H' product, 2 depth union all
select 9 id , 'I' product, 0 depth union all
select 10 id , 'J' product, 1 depth union all
select 11 id , 'K' product, 2 depth union all
select 12 id , 'A' product, 2 depth union all
select 13 id , 'B' product, 2 depth union all
select 14 id , 'L' product, 1 depth union all
select 15 id , 'E' product, 2 depth union all
select 16 id , 'D' product, 2 depth 
), b as (
select 'A' bundle_product , 'B' product, 1 sort union all
select 'A' bundle_product , 'F' product, 2 sort union all
select 'B' bundle_product , 'C' product, 1 sort union all
select 'B' bundle_product , 'D' product, 2 sort union all
select 'B' bundle_product , 'E' product, 3 sort union all
select 'F' bundle_product , 'H' product, 1 sort union all
select 'F' bundle_product , 'G' product, 2 sort union all
select 'I' bundle_product , 'J' product, 1 sort union all
select 'I' bundle_product , 'L' product, 2 sort union all
select 'J' bundle_product , 'A' product, 1 sort union all
select 'J' bundle_product , 'B' product, 2 sort union all
select 'J' bundle_product , 'K' product, 3 sort union all
select 'L' bundle_product , 'D' product, 1 sort union all
select 'L' bundle_product , 'E' product, 2 sort 
)

테이블 A 

테이블 B

1. 0depth 끼리는 id 순서가 빠른것

2. bundle 테이블의 sort 순서대로

조회를 하고싶은데요. 

최종 순서는 위와같이 나와야 하는데 방법을 모르겠습니다.

고수님들의 도움이 필요합니다