SELECT A.answer, COUNT(V.answer_id) AS votes
FROM poll_answers A
 LEFT JOIN poll_votes V
 ON A.poll_id = V.poll_id
 AND A.id = V.answer_id
WHERE A.poll_id = 4 AND A.id = V.answer_id
GROUP BY A.answer