Database

[{"_id":ObjectId("63ad7cea911abe16a7e75df3"),"number":"1726218093","status_id":ObjectId("922a3bda863a4445182aeb33")},{"_id":ObjectId("a12f7cea911abe16a7e71e3a"),"number":"17182180342","status_id":ObjectId("bda863a4445182aeb33922a3")},{"_id":ObjectId("63adb3a7cea911abe16a7e75"),"number":"1735218032","status_id":ObjectId("63a4445182aeb3da83922a3b")},{"_id":ObjectId("ea911abe16a7e75df363ad7c"),"number":"1722218087","status_id":ObjectId("182aeb3392263a4445a3bda8")}]

Query

db.collection.aggregate([{$set:{status:{$switch:{branches:[{case:{$in:["$status_id",[ObjectId("63a4445182aeb3da83922a3b"),ObjectId("ea911abe16a7e75df363ad7c")]]},then:"IN_AUCTION"},{case:{$in:["$status_id",[ObjectId("8e63a4445182aeb3da83922a"),ObjectId("5c63adea911abe16a7e75df3")]]},then:"PROCESSING"}],default:"OTHERS"}}}},{$group:{_id:"$status",count:{$count:{}}}},{$group:{_id:null,data:{$push:{k:"$_id",v:"$count"}}}},{$replaceRoot:{newRoot:{$arrayToObject:"$data"}}}])

Result