Usa la funzione FROM_UNIXTIME(unix_timestamp,format)
codice:
$mese = '12';

SELECT *
FROM tabella
WHERE FROM_UNIXTIME(data_news, '%m') = '$mese'