Laravel Query, Group and counting

I have a table scheme of

|checkSumID | playerID | team | gameResult | pickOrder | pickupRecordLocatorID

I have hundreds of results and I am trying to identify the following groupbed by playerID.

I want to count how many times gameResult is a Win or a Loss only when pickOrder value is 0. I would like to display it in an array format such as

array(
  'PlayerID' => '2837192',
    'data' => array(
       'win' => '9',
       'Loss' => '3'
      )
   ),
   ...
)

Any help would be greatly appreciated. Please let me know if you have any questions.

from Newest questions tagged laravel-5 - Stack Overflow http://bit.ly/2Qbfnnn
via IFTTT