To me it's an adverb/adverbial particle of the phrasal verb join in. Others here might disagree. Anyway, I would correct the sentence to:
Sports day is an occasion which we can all join in on.
The extra on is necessary (to join in on sthg) but makes for a slightly awkward phrasing.