Following Json needs to group by kecamatan to get array of desa along with count if kecamatan have same array value.
{
"data": [
{
"ID": 47,
"kecamatan": "Benteng",
"desa": "Benteng Selatan"
},
{
"ID": 48,
"kecamatan": "Benteng",
"desa": "Benteng Selatan"
},
{
"ID": 49,
"kecamatan": "Benteng",
"desa": "Benteng Utara"
},
{
"ID": 50,
"kecamatan": "Bontomantene",
"desa": "Garaupa"
}
]
}
expected output :-
- Benteng [Benteng selatan] = 2
- Benteng [Benteng Utara] = 1
- Bontomantene [Garaupa] = 1