django 跨表查询

submits=Submit_record.objects.filter
(assignment__group=group,
is_new=1,
submitter=f)
.select_related('assignment__group')

class Submit_record(models.Model):
    time = models.DateTimeField("提交时间", default=timezone.now)
    submitter = models.ForeignKey(User, on_delete=models.CASCADE, verbose_name="提交人", related_name="personal_submits")
    assignment = models.ForeignKey(Assignment, on_delete=models.CASCADE, verbose_name="任务编号",
                                   related_name="all_submits")
    filepath = RestrictedFileField(verbose_name="文件路径", upload_to=user_directory_path, max_upload_size=52428800,
                                   default='')
    is_new = models.BooleanField(verbose_name="是否最新记录", default=True)

    class Meta:
        app_label = 'group'
        db_table = 'Submit_record'

    def __str__(self):
        text = str(self.assignment) + "+" + str(self.submitter) + "+" + str(self.time)
        return text