子查询选择where子句

我有这个SQL语句：

SELECT * FROM result WHERE bet_id IN (SELECT id FROM bet WHERE STATUS="Active")

这是我的看法：

def manageresult(request):
    if 'usid' in request.session:
        result = Result.objects.all()
        admin = Admin.objects.get(id=request.session['usid'])
        return render(request, 'manageresult.html', {'result':result,'admin':admin})
    else:
        return redirect('login')

如何更改result = Result.objects.all()为该sql语句？这是下注模型：

class Bet(models.Model):
    status = models.CharField(max_length=20, default="Active")

这是结果模型：

class Result(models.Model):
    bet = models.OneToOneField(Bet, on_delete=models.CASCADE)