$query = "SELECT nome, cognome,..., max(m.data) AS maxData
FROM table_compleanni
HAVING DATE_SUB(CURDATE(),INTERVAL 2 MONTH) <= maxData
ORDER BY maxData DESC";