mysql，列表转横表

select order_id, group_concat(commodity_name order by commodity_id separator ',') as commodity_names from order_list
where is_second_payoff=1
group by order_id