select brand_id,group_concat(person) person, group_concat(group) group from table group by brand_id;