Mazher Mahmood, a British journalist known for his undercover work posing as a "fake sheikh", has been suspended by The Sun after the collapse of a celebrity trial in which he was a main witness.