MySQL想要查询多个一对多

SELECT
    id,
    ht_code,
    create_psn,
    create_time,
    update_psn,
    update_time,
    signing_time,
    NAME,
    total,
    overage,
    principal_info,
    our_attribute,
    memo,
    (SELECT group_concat(file_url) FROM bd_deal_file WHERE pk_id = deal.id group by pk_id) as urlList
FROM
    bd_deal as deal
group_concat(file_url) FROM bd_deal_file WHERE pk_id = deal.id group by pk_id) as urlList
FROM
    bd_deal as deal

 

 

group_concat() 函数会默认将分组后的列组合成一个字符串,默认用使用","分割。

 

效果如上图

对于该函数更详细的介绍请看

https://www.cnblogs.com/wenxinphp/p/5841430.html