It is narrated from Ibn Mas'ud (may Allah be pleased with him) that he stated: The Prophet (ﷺ) said: "Medina is between two springs of the sky, one is the spring of Syria and the other is the spring of Yemen, and this is a land with little rainfall."
Hadith Referenceمسند الإمام الشافعي / كتاب العيدين والأضاحي والاستسقاء / 533
Hadith Takhrijاسناده ضعیف لضعف من لا يتهمه الشافعي وهو ابراهيم بن محمد أخرجه البيهقي في المعرفة السنن والآثار (2040)۔