in the cleaning team shifts table, record 1, is the record for ct_volunteer 6644.
the value in the cleaning team ID column is 10.
you are relating the serving_team.id = cleaning_team_shifts.cleaning_team_id
in the serving team table, ID 10 is clerical.
i dont know what else to tell you, it is returning clerical because that is the related value in your database