I have two models, Game, and User (a player).
In my games table, I store the ID of player_one_id, player_two_id, along with their scores, and the date that they played.
Firstly, I would like to know how to set up the relationships as a player (User) can either be player one or player two so it isn't a straight forward hasMany relationship.
Secondly, I would also like to know how to group by the day that games were played on when displaying all games. So for example:
Mike 18 - 21 John
John 19 - 21 Ben
Mike 21 - 19 John