用到的主要方法“FIND_IN_SET、GROUP_CONCAT”
FIND_IN_SET(目标表id,ids集合1,2,3,4)

SELECT
a.farm_name,a.address,a.person_phone,IFNULL(GROUP_CONCAT(b.product_name SEPARATOR ','),'暂无产品') as productNames,a.image
FROM
trace_base a
LEFT JOIN trace_product b ON FIND_IN_SET(b.id,a.products)
WHERE
a.tenant_id=2020010602
GROUP BY a.farm_name,a.address,a.person_phone,a.image

运行如下
image