cry in one's beer 顾影自怜；借酒浇愁

【例句】
John sits around in a bar all day crying in his beer since his girlfriend dumped him. 　　
女友和他分手后，约翰就一天到晚坐在酒吧里借酒消愁。

Well, if you won't come with me tonight I'll just have to stay home and cry in my beer.
唉，如果你今晚不肯来陪我，我就只好呆在家里借酒消愁了。