Praise be to Allah.
We put this question to Shaykh Muhammad ibn Saalih al-‘Uthaymeen, may Allaah preserve him, who answered as follows:
This du’aa’ includes a kind of transgression. Abu Bakr will have wives, and ‘Umar will have wives and ‘Ali will have wives. But a woman should pray to Allaah and say, “O Allaah, I ask You for Paradise and the words and actions that will bring me closer to it.” In Paradise there will be all that a person can desire and all that can delight the eyes. And Allaah knows best.