You can visit other players' cities by simply clicking on their portraits which you can see on the social bar at the bottom of the screen.