SELECT
   c.id,
   c.name,
   GROUP_CONCAT(cph.phone_number SEPARATOR ';') AS phone
FROM counteragents c
LEFT JOIN counteragents_phone cph ON c.id = cph.counteragent_id
GROUP BY id