There are many false prophets, but there is only one who is partnered with the anti-Christ in the Book of Revelation.
His fate is to be thrown into the Lake of Fire by an angel appointed by Jesus at the time of the Second Coming, which is at the end of the Tribulation.
The false prophet is mentioned as such, 3 times in the book of Revelation.
Rev 16:13 (KJV) “And I saw three unclean spirits like frogs come out of the mouth of the dragon, and out of the mouth of the beast, and out of the mouth of the false prophet.”
Rev 19:20 (KJV) “And the beast was taken, and with him the false prophet that wrought miracles before him, with which he deceived them that had received the mark of the beast, and them that worshipped his image. These both were cast alive into a lake of fire burning with brimstone.”
Rev 20:10 (KJV) “And the devil that deceived them was cast into the lake of fire and brimstone, where the beast and the false prophet are, and shall be tormented day and night for ever and ever.”