原生mysql多对多关联问题

按id分组，使用group_concat组合拼接：

group_concat(d.car_long, ","),

你要把多行的数据放在一起 就只能group by

select a.id,b.cargo_name,c.city_start,c.city_end,d.car_long,e.car_model
    ,a.price_type,a.freight,a.created_at 
from deliver_goods as a
    left join deliver_goods_cargos_info as b ON b.goods_id = a.id
    left join deliver_goods_addresses as c ON c.goods_id = a.id
    left join (
        select a.id,group_concat(d.car_long, ",") car_long
        from deliver_goods as a
            left join deliver_goods_cars_long as d ON d.goods_id = a.id
        group by a.id
        -- where a 表条件
    ) as d ON d.id = a.id
    left join deliver_goods_cars_model as e ON e.goods_id = a.id

试试看是否 可以