The role of prayer for the sick is needed to accompany each endeavor in the search for healing of the disease. The best prayer to do is with a sincere heart and confidence will be allowed by Allah SWT. There are various sayings of the prayers of the sick taught by the Prophet Muhammad to all his people through the teachings of Islam.

Quoted in the book 'Healing with Prayer and Remembrance of the Prophet Muhammad SAW by Muhammad Abdul Ghoffar mentioned that one of the instructions of the Prophet Muhammad SAW is healing yourself using prayer and remembrance. The Apostle advised his followers to try to heal both family and friends or anyone who was sick with prayers taught by him.

Mentioned in the Koran, Surah Al-Baqarah verse 186, Allah SWT says:

وَإِذَا سَأَلَكَ عِبَادِي عَنِّي فَإِنِّي قَرِيبٌ ۖ أُجِيبُ دَعْوَةَ الدَّاعِ إِذَا دَعَانِ ۖ فَلْي

Meaning: And if My servants ask you about Me, then (answer), that I am close. I grant the prayers of those who pray when he asks me, then they should fulfill (all my commandments) and let them believe in me, so that they are always in the truth.

From the history of Imam Muslim from Jabir bin Abdillah he said that the Prophet said:

لِكُلِّ دَاءٍ دَوَاءٌ ، فَإِذَا أَصَابَ الدَّوَاءُ الدَّاءَ ، بَرَأَ بِإِذْنِ اللهِ عَزَّ وَجَلَّ

Meaning: Every disease must have medicine. If a medicine is in accordance with his illness then he will recover with the permission of Allah Subhanahu wa Ta'ala. "(HR. Muslim)

"If you go to someone who is sick, then ask him to pray for you, because in fact his prayer is like an angel's prayer." (Narrated by Ibnu Majah and Ibn Sunni with authentic sanad).

May be useful
Thank you