title: Laravel Eloquent concat and groupBy() AND return one title of each group
body: <p>I have a table that contains, amongst other columns, a column of browser versions. And I simply want to know from the record-set, how many of each type of browser there are.</p>
  <p>my code is :</p>
  <pre class="lang-php prettyprint-override"><code>$whereBrowser = [['owner', '=', 12]];
          $browser = ProfileTracker::where($whereBrowser)-&gt;whereBetween('created_at', [Carbon::now()-&gt;startOfMonth(), Carbon::now()-&gt;endOfMonth()])-&gt;select([
              DB::raw('browser'),
              DB::raw('COUNT(browser) as value')
          ])-&gt;groupBy(&quot;browser&quot;)-&gt;orderBy(&quot;value&quot;, &quot;desc&quot;)-&gt;take(10)-&gt;get();
  
  </code></pre>
  <p>output :</p>
  <pre><code>          &quot;browser&quot;: [
                {
                    &quot;browser&quot;: &quot;Chrome Mobile 84&quot;,
                    &quot;value&quot;: 144
                },
                {
                    &quot;browser&quot;: &quot;Chrome Mobile 80&quot;,
                    &quot;value&quot;: 84
                },
                {
                    &quot;browser&quot;: &quot;Chrome 84&quot;,
                    &quot;value&quot;: 27
                },
                {
                    &quot;browser&quot;: &quot;Chrome 30&quot;,
                    &quot;value&quot;: 22
                },
                {
                    &quot;browser&quot;: &quot;Chrome Mobile 83&quot;,
                    &quot;value&quot;: 19
                },
                {
                    &quot;browser&quot;: &quot;Chrome Mobile 47&quot;,
                    &quot;value&quot;: 10
                },
                {
                    &quot;browser&quot;: &quot;Firefox 79&quot;,
                    &quot;value&quot;: 8
                },
                {
                    &quot;browser&quot;: &quot;Mobile Safari&quot;,
                    &quot;value&quot;: 8
                },
                {
                    &quot;browser&quot;: &quot;Mobile Safari 13.1.2&quot;,
                    &quot;value&quot;: 6
                }
            ],
           
        }
  </code></pre>
  <p>I want to group all browsers, without the browser version like this:</p>
  <pre><code>            &quot;browser&quot;: [
                  {
                      &quot;browser&quot;: &quot;Chrome&quot;,
                      &quot;value&quot;: 306
                  },
                  {
                      &quot;browser&quot;: &quot;Safari&quot;,
                      &quot;value&quot;: 14
                  },
                  {
                      &quot;browser&quot;: &quot;Firefox&quot;,
                      &quot;value&quot;: 8
                  },
              ],
             
          }
  </code></pre>