Kevin Mayer is leaving after two months at the video-sharing app at the centre of US-China tensions.