The close friend of a footballer has confirmed the death of his wife and two children in a heartbreaking social media post