Django db query

[Suraj Thapa FC]

class courses(models.Model):

    level = (

        ('beginner', 'Beginner Level'),

        ('intermediate', 'Intermediate Level'),

        ('expert', 'Expert Level'),

        ('all level', 'All Level'),

     )

    type = (

         ('live', 'LIVE'),

         ('on demand', 'On Demand'),

     )

    ins_id = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)

    coursetype = models.CharField(max_length=50,choices=type, default="on demand")

    cid = models.UUIDField(default=uuid.uuid4, editable=True, primary_key=True)# course id

    course_title = models.CharField(max_length=255, default="")

    course_sub_title = models.CharField(max_length=255,default="")

    course_level = models.CharField(max_length=255, choices= level, default="beginner")

    course_main_cat = models.ForeignKey(courses_main_categories, on_delete=models.CASCADE)

    course_sub_cat = models.ForeignKey(courses_sub_categories, on_delete=models.CASCADE)

    course_permalink = models.SlugField(max_length=255,default="")

    image_path = models.ImageField(upload_to="media",blank=True,default="")

    is_published = models.BooleanField(default=False)

    is_in_draft = models.BooleanField(default=True)

    a_pending = models.BooleanField(default=False)

    i_pending = models.BooleanField(default=False)

    created_at = models.DateTimeField(auto_now_add=True)

    live_course_start = models.DateTimeField(auto_now_add=True)

    live_course_end = models.DateTimeField(auto_now_add=True)

    course_desc = models.CharField(max_length=255, default="")

    primarily_taught = models.CharField(max_length=255, default="")

class course_review_report(models.Model):

    task_id = models.BigAutoField(primary_key = True)

    expert_id = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)

    cid = models.ForeignKey(courses,on_delete = models.CASCADE)

    is_completed = models.BooleanField(default=False)

    is_pending = models.BooleanField(default=True)

    assigned_date = models.DateTimeField(auto_now_add = True)

    review_completion_date = models.DateTimeField(auto_now_add = True)

This is my project models

I want to get those cid from courses tables which have the is_published = True and based on this I want to get the course_review_report data on the basis of  distinct cid. 

Can anyone write the querryset for the same..