Количество аккаунтов на каждом прокси

SELECT
     proxy.id AS proxy_id,
     COUNT(account_vk.login) AS account_acount
FROM
     likepanel.proxy
     INNER JOIN likepanel.account_vk
     ON account_vk.proxy_id = proxy.id
WHERE
     account_vk.STATUS = 'active'
     OR account_vk.STATUS = 'need_token'
GROUP BY proxy.id