[{"_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","channel":"$channel","status":"$status"},"channelCount":{"$sum":1}}},{"$group":{"_id":{"city":"$_id.city",},"channels":{"$push":{"name":"$_id.channel","status":"$_id.status","count":"$channelCount"},},"count":{"$sum":"$channelCount"}}},{$sort:{"_id.city":1}}])