pg json group by

{
  "tot": 1,
  "date": "2017-09-08",
  "category_id": 3,
  "name": "Uniform Issues"
},
{
  "tot": 1,
  "date": "2017-09-06",
  "category_id": 3,
  "name": "Uniform Issues"
},
{
  "tot": 2,
  "date": "2017-09-08",
  "category_id": 2,
  "name": "HR Issues"
}

SELECT g.category_name, json_agg(g) as dates FROM
(
  SELECT count(*) AS tot, i.created_at::date AS date, ic.id AS category_id, ic.name AS category_name
  FROM {Issue} i
  INNER JOIN {IssueCategory} ic ON ic.id = i.issue_category_id
  GROUP BY i.issue_category_id, ic.name, ic.id, i.created_at::date
) g
GROUP BY g.category_name


{
  "category_name": "Uniform Issues",
  "dates": [
      {
          "tot": 1,
          "date": "2017-09-08",
          "category_id": 3,
          "category_name": "Uniform Issues"
      },
      {
          "tot": 1,
          "date": "2017-09-06",
          "category_id": 3,
          "category_name": "Uniform Issues"
      }
  ]
},
{
  "category_name": "HR Issues",
  "dates": [
      {
          "tot": 2,
          "date": "2017-09-08",
          "category_id": 2,
          "category_name": "HR Issues"
      }
  ]
}