Getting related records

I have a question about how to get records that are related but are several tables away. As an example:

I have the following model:

A Course has Sessions (times the course run).

Sessions are associated with Users through an association table.

So, what I want to do is bring back all Courses and sessions for a particular user (for a particular time period). How would I bring this data back using a relational model?