The death of a loved one is not something we pray for. It could be very painful and some persons do not go back to normal after they lose someone. But there is hope, the dead shall rise again on resurrection morning and we all shall be together again with our heavenly father in glory.
There is hope for there shall be no more death and sorrow when Jesus comes to take us home.
Sorry for your loss brother but you will surely see your dear friend again.