title: Django orm query_set
body: <p>I searched for various information on the Internet,</p>
  <p>but I didn't get the desired results.</p>
  <p>I am trying to get the following as my output but:</p>
  <pre><code>[
      {
          &quot;vehicle__name&quot;: &quot;AAA&quot;,
          &quot;vehicle__number&quot;: &quot;123&quot;,
          &quot;user_id__first_name&quot;: [&quot;name1&quot;,&quot;name2&quot;],
          &quot;vc&quot;: 8
      },
      {
          &quot;vehicle__name&quot;: &quot;BBB&quot;,
          &quot;vehicle__number&quot;: &quot;111&quot;,
          &quot;user_id__first_name&quot;: [&quot;name3&quot;],
          &quot;vc&quot;: 5
      }
  ]
  </code></pre>
  <p>I don't know what to do.</p>
  <p>Can you help me?</p>
  <p>My code:</p>
  <pre><code>a = TestManager.objects.filter(company_code__in=sub_company).values(
              'vehicle__name',
              'vehicle__number',
              'user_id__first_name'
          ).annotate(
              vc=Count(&quot;vehicle__name&quot;),
          ).order_by(
              'vehicle__name',
          )
  </code></pre>
  <p>Output:</p>
  <pre><code>[
      {
          &quot;vehicle__name&quot;: &quot;AAA&quot;,
          &quot;vehicle__number&quot;: &quot;123&quot;,
          &quot;user_id__first_name&quot;: &quot;name1&quot;,
          &quot;vc&quot;: 9
      },
      {
          &quot;vehicle__name&quot;: &quot;AAA&quot;,
          &quot;vehicle__number&quot;: &quot;123&quot;,
          &quot;user_id__first_name&quot;: &quot;name2&quot;,
          &quot;vc&quot;: 1
      },
      {
          &quot;vehicle__name&quot;: &quot;BBB&quot;,
          &quot;vehicle__number&quot;: &quot;111&quot;,
          &quot;user_id__first_name&quot;: &quot;name3&quot;,
          &quot;vc&quot;: 10
      }
  ]
  </code></pre>