使用MySQL在不同字段上使用多个GROUP_CONCAT

I have a query like this:

我有这样的查询：

SELECT product.id,
       GROUP_CONCAT(image.id) AS images_id,
       GROUP_CONCAT(image.title) AS images_title,
       GROUP_CONCAT(facet.id) AS facets_id
...
GROUP BY product.id
SELECT p