Django: Access model through another model

Question

class Project(models.Model):
    title = models.CharField()  

class Job(models.Model):
    name = models.CharField()
    user = models.ForeignKey(User)
    project = models.ForeignKey(Project)

I have many jobs for each project. How do i get a list of all users of all jobs of a project?
I came up with this:

users = set()
for job in project.job_set.all():
    users.add(job.user)

Is there an easier way without explicitely looping through every job?

Answer 1

Use Django's join syntax and start from your User model instead:

users = User.objects.filter(job_set__project=project).distinct()

Answer 2

Alternatively, you could use a ManyToMany relation from Project to User through the Job model which is in effect a join model:

class Project(models.Model):
   users = models.ManyToManyField(User, through='Job')
   ...

And then simply do:

project.users.all()