It was narrated that Ibn 'Abbas (رضي الله عنه) said:

The Prophet (ﷺ) passed by me near Zamzam, and he called for water and asked for something to drink, so I brought him a bucket of Zamzam water and he drank whilst standing.