The GROUP BY function in query builder is only giving me choices from 1 table (pcms2_users). I manually added the other column I'm trying to show (serving_team.team), but it didn't change the results of my search.
$ServingQuery->setQuery("SELECT pcms2_users.UserID, pcms2_users.UserFirstName, pcms2_users.UserLastName, kids_program_shifts.kp_team_id, kids_program_shifts.kp_volunteer, cleaning_team_shifts.cleaning_team_id, cleaning_team_shifts.ct_volunteer, serving_team.* FROM pcms2_users LEFT OUTER JOIN kids_program_shifts ON pcms2_users.UserID = kids_program_shifts.kp_volunteer LEFT OUTER JOIN cleaning_team_shifts ON pcms2_users.UserID = cleaning_team_shifts.ct_volunteer LEFT OUTER JOIN serving_team ON cleaning_team_shifts.cleaning_team_id = serving_team.id WHERE pcms2_users.UserFirstName = ? OR pcms2_users.UserLastName = ? GROUP BY pcms2_users.UserFirstName, pcms2_users.UserLastName, serving_team.team");