Abu Hurairah (RA) narrated it directly from Allah's Apostle' (ﷺ) having said this: A prayer in my mosque is a thousand times more excellent than a prayer in any other mosque, except Masjid al-Haram (Mosque of the Ka’bah).
Related hadith on this topic