Prova così
codice:
SELECT `from`, max(`date`) FROM `votes` WHERE MONTH(`date`) = MONTH(CURDATE()) AND YEAR(`date`) = YEAR(CURDATE()) AND `to`='$this->uid' GROUP BY `from`