查询订单表中同一父订单下的所有子订单（蜜芽）

select b.*
from orders as a
left join orders as b on a.superior_order_code = b.superior_order_code
where a.order_code = '15051035588773'