Mayor? When does he return

How or when do we get to play the mayor again?

If you’re referring to the introductory game, that’s just a tutorial. You can replay it as many times as you like. It’s in the Main Menu > Find Game > Solo > The Deck Casino > Introduction. Sadly, there is no sequel to it. The Mayor doesn’t return anywhere else in the game. It’s a cool character though.