如果我正确,您可以使用django raw
sql获取必要的数据:
q = """SELECt yourappname_category.id, yourappname_category.name, COUNT(outfit_id) > 0 as added FROM yourappname_category LEFT JOIN yourappname_category_outfits ON yourappname_category.id = yourappname_category_outfits.category_id AND yourappname_category_outfits.outfit_id=%sWHERe yourappname_category.owner_id=%sGROUP BY yourappname_category.id, yourappname_category.name"""categories = Category.objects.raw(q, [obj.id, user.id])results = [{'id': c.id, 'name': c.name, 'added': c.added} for c in categories]


