Bagaimana ya cara nya membuat output json seperti ini dari data mysql :

dt = {
"otp": "<OTP>",
"awlr": [{
  "id": "ID SENSOR",
  "latlong": ["latitude", "longitude"],
  "ts": "YYYY-MM-DD HH:MM:SS",
  "tma": "Tinggi muka air (mdpl)",
  "vol_e": "Volume efektif (m3)",
  "q_1": "Outflow turbin",
  "q_2": "Outflow air baku",
  "q_3": "Outflow irigasi",
  "q_4": "Outflow pelimpah",
  "q_5": "Outflow pemeliharaan",
  "q_6": "Outflow HJV",
  "qtotal": "Total Outflow (m3/s)"
}, {
..and so on..
}],
"vno": [{

"id": "ID SENSOR",
"latlong": ["latitude", "longitude"],
"ts": "YYYY-MM-DD HH:MM:SS",
"q": "q/lt/s",
"h": "hcm"
}, {
..and so on..
}],
"pzo": [{
"id": "ID SENSOR",
"latlong": ["latitude", "longitude"],
"ts": "YYYY-MM-DD HH:MM:SS",
"z": "kedalaman (mdpl)",
"sta": "stasiunari",
"m": "mH2O"

}, {
..and so on..
}]
}


Saya ingin mengkonversi JSON dari tabel mysql berikut :
$query = mysqli_query($conn, 'SELECT id_sensor,latlong,ts,tma,vol_e,q_1,q_2,q_3,q_4,q_5,q_6,qtotal FROM tr_data WHERE id_hardware="4086" AND rowid > 4503000');
while($row = mysqli_fetch_assoc($query)) {
$data[] = $row; 

}