Database

[{"_id":ObjectId("654b7348e704b8abba8af17e"),"name":"","email":"","status":"Active"},{"_id":ObjectId("654b6c662f38d9e087086193"),"name":"","email":"","status":"Pending"},{"_id":ObjectId("654b7fbae8392eddee2d1a31"),"name":"","email":"","status":"Pending"},{"_id":ObjectId("653222c20489664953bbaf1a"),"name":"","email":"","status":"Active"},{"_id":ObjectId("653269653bc13f1b96c6c37d"),"name":"","email":"","status":"Active"}]

Query

db.collection.aggregate([{$addFields:{acc_status_sort:{$cond:{if:{$eq:["$_id",ObjectId("653222c20489664953bbaf1a")]},then:0,/** exact match gets lowest value*/else:{$cond:{if:{$eq:["$status","Pending"]},then:1,/** status pending gets lowest value*/else:2}}}}}},{$sort:{acc_status_sort:1}},/** remove the extra fields added* comment out this part to see the sorting fields in results*{* $unset: "acc_status_sort"*}*/])

Result