How to filter on joined table

I have three tables:

games

games

and

players

players

and

users

users

. A user can join a

game

game

, at which point a

player

player

record is created with a unique constraint on

game_id,user_id

game_id,user_id

.

I want to select all games for which a particular

player

player

has joined. So, I need to filter on the joined

players

players

table. But how? Also, I want to include games whose column

kind

kind

open

open

. So that will require some kind of or method, right?