A 34-year-old man who was missing along with two young children has been found safe and well.