mysql查询操作

1.将这个结果弄成下面的结果

sql写法为：select room_attr_id,  room_id,  attr_id, group_concat(attr_value separator ',') as attr_value from rz_rooms_attr where room_id=31 group by attr_id;