I have write a simple query in mongoDB and get all data related to product id. Now I want to convert my response in array of object. Please see below.

QUERY:

db.collection.find({ "product_id": 1212 })

GETTING RESPONSE :

[
  {
    "product_id": 1212,
    "name": "sprit",
    "category_id": 1234,
    "category": "drink"
  },
  {
    "product_id": 1212,
    "name": "sprit",
    "category_id": 2122,
    "category": "soda"
  },
  {
    "product_id": 1212,
    "name": "sprit",
    "category_id": 2121,
    "category": "mocktail"
  },
  {
    "product_id": 1212,
    "name": "sprit",
    "category_id": 2121,
    "category": "mocktail"
  }
]

I want to convert same data in different format by MongoDB query and remove duplicate category id.

REQUIRED RESPONSE:

[
  {
    "product_id": 1212,
    "name": "sprit",
    "categogies": [
      {
        "category_id": 1234,
        "category": "drink"
      },
      {
        "category_id": 2123,
        "category": "soda"
      },
      {
        "category_id": 2121,
        "category": "mocktail"
      }
    ]
  ]