How to make response json groupby and get all value of grouped

How to get data grouped and get all value of data in array

example

id name    date       public
1  hi   2018-10-19    true
2  hai  2018-10-20    true
3  bye  2018-10-19    true

than i want make response json like

data:{
"2018-10-19": [
  {
     "name": "hi",
     "public": true
  },
  {
     "name": "bye",
     "public": true
  }
 ],
 "2018-10-20": [
  {
     "name": "hai",
     "public": true
  }
 ],
}

via Chebli Mohamed