I gave the Messenger of Allah ﷺ water from Zamzam to drink, and he drank it while standing.
سقيت رسول الله ﷺ من زمزم، فشرب وهو قائم.
Bukhari narrated it in the Book of Drinks (5617), and Muslim in the Book of Drinks (2027: 117), both from the hadith of Asim Ahwal, from Shaybi, from Ibn Abbas, who mentioned it.