sql:
SELECT ev_module.id, ev_module.name, ev_module.parent_id, ev_module.module_type, ev_module.pcs as qty, ev_module.details, ev_module.module_total_price, ev_module.notes as price, ev_module.notes as pcs FROM ev_module WHERE ev_module.module_type = 'module' AND ev_module.parent_id = '1' UNION ALL SELECT ev_module.id, ev_item.name, ev_module.parent_id, ev_module.module_type, ev_module.pcs as qty, ev_module.details, ev_module.module_total_price, ev_item.price, ev_item.pcs FROM ev_module, ev_item WHERE ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '1' UNION ALL SELECT ev_module.id, ev_fabrication.name, ev_module.parent_id, ev_module.module_type, ev_module.pcs as qty, ev_module.details, ev_module.module_total_price, ev_fabrication.price, ev_fabrication.vendor_id as pcs FROM ev_module, ev_fabrication WHERE ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '1' ORDER by parent_id ASC, id ASC

Array ( [0] => Array ( [id] => 4 [name] => Front suspension [parent_id] => 1 [module_type] => module [qty] => 1 [details] => Control arms, coil overs, all brackets for mounting, bushings, ball joints, plates [module_total_price] => 0 [price] => [pcs] => ) [1] => Array ( [id] => 10 [name] => Floor [parent_id] => 1 [module_type] => module [qty] => 1 [details] => All the tslot parts that are critical to making this thing work. Does NOT include dash, front hoop, main hoop, roof, brake or steering supports, swing arms, control arms, seat mounts or switch mounts. Includes everything else, including wheel arches, [module_total_price] => 0 [price] => [pcs] => ) [2] => Array ( [id] => 18 [name] => Dual Wheel Floor - Single Side [parent_id] => 1 [module_type] => module [qty] => 2 [details] => Floor of front of tadpole trike or four-wheel vehicle - one side. Left and right sides of this module are mirror images, thus quantity of two for this but not its siblings [module_total_price] => 0 [price] => [pcs] => ) [3] => Array ( [id] => 158 [name] => Deflector [parent_id] => 1 [module_type] => module [qty] => 1 [details] => The angled portion of the front of Evie. This portion connects to the floor or Mustang 2 cross bar. This will most likely contain many more sub-modules in a wheel arch front suspension [module_total_price] => 0 [price] => [pcs] => ) [4] => Array ( [id] => 175 [name] => Hood [parent_id] => 1 [module_type] => module [qty] => 1 [details] => The flat area forward of the front hoop [module_total_price] => 0 [price] => [pcs] => ) [5] => Array ( [id] => 291 [name] => Rear Suspension [parent_id] => 1 [module_type] => module [qty] => 1 [details] => Unlike the front suspension, this does include the aluminum bar that fits over the BLDC shaft. Also includes the 4 hole brackets that mount to the chassis [module_total_price] => 0 [price] => [pcs] => ) )
Module Data