Simply navigate to http://www.google.com/calendar/iphoneselect and enable the calendars you wish to sync!

From a UX standpoint, I find it a bit odd that Google Calendar doesn’t automatically sync all calendars, but this may be an attempt to avoid overwhelming the user.