Hanafi
The sources give no view for it here.
شرب ماء زمزم
هل يُسنّ شرب ماء زمزم لتحصيل المطلوب في الدنيا والآخرة؟
Each school’s answer
In our wordsHanafi
Not stated in the sources
Maliki
Not stated in the sources
Shafi'i
Not stated in the sources
Hanbali
Not stated in the sources
The texts
١٥ - ذَهَبَ الْعُلَمَاءُ إِلَى سُنِّيَّةِ شُرْبِ مَاءِ زَمْزَمَ لِمَطْلُوبِهِ فِي الدُّنْيَا وَالآْخِرَةِ؛ لأَِنَّهَا مُبَارَكَةٌ، لِقَوْلِهِ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ: مَاءُ زَمْزَمَ لِمَا شُرِبَ لَهُ. (٢)
«الموسوعة الفقهية الكويتية» (Kuwait) entry «تبرك» vol. 10 p. 74
From the schools’ own books
Maliki
The sources give no view for it here.
Shafi'i
The sources give no view for it here.
Hanbali
The sources give no view for it here.
What is «in our words» is our standard wording; the books’ texts stay as they are.