"The drink most beloved to the Messenger of Allah (ﷺ) was the sweet, cool drink."

This was reported similarly by more than one narrator from Ibn 'Uyainah from Ma'mar, from Az-Zuhri, from 'Urwah from 'Aishah. What is correct what was reported by Az-Zuhri from the Prophet (ﷺ) in Mursal form.
Jami` at-Tirmidhi Book 26, Hadith 36
← Previous Hadith That the Prophet (ﷺ) said: "The one providing water for people is the last of them to drink."

He said: There is something on this topic from Ibn Abi Awfa.

This Hadith is Hasan Sahih.

Jami` at-Tirmidhi Book 26, Hadith 35 Next Hadith → "The Prophet (ﷺ) was asked: 'Which drink is the best ?' He said: 'The sweet, cool drink."

This is how 'Abdur-Razzaq reported it from Ma'mar, from Az-Zuhri, from the Prophet (ﷺ) in Mursal form. This is more correct that the narration of Ibn 'Uyainah (no. 1895).

Jami` at-Tirmidhi Book 26, Hadith 37