SELECT user_id, concat('用户购买的商品id为:[', group_concat(item_id Separator ','), ']') AS item_ids FROM shoppingRecords GROUP BY user_id;