โค้ด: เลือกทั้งหมด
WITH RECURSIVE children AS (
SELECT bom_id, id
FROM mrp_bom
WHERE bom_id IN (47,46,45,44,43)
UNION ALL
SELECT a.bom_id, a.id
FROM mrp_bom a
JOIN children b ON(a.bom_id = b.id)
)
SELECT * FROM children order by bom_id