Anas (May Allah be pleased with him) reported

The Messenger of Allah (ﷺ) came to his son Ibrahim (May Allah be pleased with him) when he was breathing his last. The eyes of the Messenger of Allah (ﷺ) began shedding tears. 'Abdur-Rahman bin 'Auf (May Allah be pleased with him) said, "O Messenger of Allah, you too weep?" He (ﷺ) said, "O Ibn 'Auf! It is mercy." Then he began to weep and said, "The eyes are shedding tears and the heart is grieved, and we will not say except what pleases our Rubb. O Ibrahim! Indeed we are grieved by your departure."

[Al-Bukhari].