رَبِّ هَبْ لِي مِن لَّدُنكَ وَلِيًّا يَرِثُنِي وَيَرِثُ مِنْ آلِ يَعْقُوبَ وَاجْعَلْهُ رَبِّ رَضِيًّا
Rabbi hab li min ladunka waliyyan yarithuni wa yarithu min ali Ya'qub, waj'alhu Rabbi radiyya
My Lord, grant me from Yourself an heir who will inherit from me and from the family of Ya'qub. And make him, my Lord, pleasing to You.
Zakariyya's (AS) more detailed du'a for a son. He did not just want any child — he wanted one who would inherit the prophetic legacy of the family of Ya'qub (AS). And the final request: "make him pleasing to You" — not pleasing to me, not successful by worldly standards, but radiyya — someone Allah is pleased with. The highest aspiration a parent can have for their child.
Related Du'as
رَبِّ لَا تَذَرْنِي فَرْدًا وَأَنْتَ خَيْرُ الْوَارِثِينَ
My Lord, do not leave me alone with no offspring, while You are the best of inheritors.
Sahihرَبِّ اجْعَلْنِي مُقِيمَ الصَّلَاةِ وَمِن ذُرِّيَّتِي رَبَّنَا وَتَقَبَّلْ دُعَاءِ رَبَّنَا اغْفِرْ لِي وَلِوَالِدَيَّ وَلِلْمُؤْمِنِينَ يَوْمَ يَقُومُ الْحِسَابُ
My Lord, make me an establisher of prayer, and from my descendants. Our Lord, accept my supplication. Our Lord, forgive me and my parents and the believers on the Day the account is established.
Sahihاللَّهُمَّ إِنِّي أَسْأَلُكَ خَيْرَهَا وَخَيْرَ مَا جَبَلْتَهَا عَلَيْهِ وَأَعُوذُ بِكَ مِنْ شَرِّهَا وَشَرِّ مَا جَبَلْتَهَا عَلَيْهِ
O Allah, I ask You for her goodness and the goodness of what You have created in her nature, and I seek refuge in You from her evil and the evil of what You have created in her nature.
Hasanاللَّهُمَّ إِنِّي أَسْأَلُكَ مِنْ خَيْرِ مَا سَأَلَكَ مِنْهُ نَبِيُّكَ مُحَمَّدٌ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ وَأَعُوذُ بِكَ مِنْ شَرِّ مَا اسْتَعَاذَ مِنْهُ نَبِيُّكَ مُحَمَّدٌ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ
O Allah, I ask You for the good that Your Prophet Muhammad ﷺ asked You for, and I seek refuge from the evil that Your Prophet Muhammad ﷺ sought refuge from.
Hasan