[{"_id":ObjectId("5f47eee763f55a095048f542"),"channel":"Z_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f543"),"channel":"S_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f544"),"channel":"Z_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f545"),"channel":"S_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f546"),"channel":"S_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f547"),"channel":"S_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f548"),"channel":"Z_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f549"),"channel":"S_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f54a"),"channel":"Z_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f54b"),"channel":"S_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f54c"),"channel":"Z_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f54d"),"channel":"S_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f54e"),"channel":"Z_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f54f"),"channel":"S_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f550"),"channel":"Z_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f551"),"channel":"S_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f552"),"channel":"Z_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f553"),"channel":"S_C","city":"A","status":1},{"_id":ObjectId("5f47eee763f55a095048f554"),"channel":"Z_C","city":"A","status":0},{"_id":ObjectId("5f47eee763f55a095048f555"),"channel":"S_C","city":"A","status":1}]

db.collection.aggregate([{$group:{_id:{city:"$city",name:"$channel",status:"$status"},count:{$sum:1}}},{$group:{_id:{city:"$_id.city",name:"$_id.name"},counts:{$push:{count:"$count",status:"$_id.status"}},count:{$sum:"$count"}}},{$sort:{"_id.city":1}},{$group:{_id:"$_id.city",channels:{$push:{name:"$_id.name",counts:"$counts",count:"$count"}},count:{$sum:"$count"}}}])