SQL LEFT JOIN多个表，包括每个连接的1个表的链接

For the sake of explaining my problem lets say I am building cars. In my DB a car is made out of parts (engine, chassis, wheel). Each part has a physical location (part_location from the table locations) which is linked via (part_location = location_id).For the sake of explaining my problem lets say