Hi Team,

Generate JSON string from table with one to many relationship data

I have a two tables.

1. Employee - EmpId, EmpName

2. Car_data - EmpId,Model,Color

I want to generate the following JSON output string.

{
  "EmpId" :"123",
  "EmpName":"Jackson",
  "Car_data":
  [{
    "EmpId" :"123",
    "Model":"2008",
    "Color":Red
  }, 
  {
    "EmpId" :"123",
    "Model":"2009",
    "Color":Black
  }]
}