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