this is the query:
$sql = "select pn.id, pn.purchased_number, pn.plan, pn.ring_to_group, count(rtg.id) as totalGroups, concat_ws(',', group_concat(rtg.group_name), group_concat(rtg.id)) as groupList from tbl_phone_numbers as pn left join tbl_rings_to_groups as rtg on rtg.user_id=pn.user_id where pn.user_id = ? and pn.status = ?"; $query = $this->db->query($sql, array($this->userId, 'Y'));
that returns the result of
default,demo,1,2 but i want to get result something like :
in MYSQL any suggestion??