Database

[{_id:ObjectId("63f61d8d99b4ee0004e76e03"),"momentid":ObjectId("63f61d8d99b4ee0004e86e03"),"userid":ObjectId("63f61d8d99b4ee0004e96e03")},{_id:ObjectId("63f61d8d99b4ee0004e71e03"),"momentid":ObjectId("63f61d8d99b4ee0004e86e04"),"userid":ObjectId("63f61d8d99b4ee0004e96e03")},{_id:ObjectId("63f61d8d99b4ee0004e72e03"),"momentid":ObjectId("63f61d8d99b4ee0004e86e05"),"userid":ObjectId("63f61d8d99b4ee0004e96e03")},{_id:ObjectId("63f61d8d99b4ee0004e73e03"),"momentid":ObjectId("63f61d8d99b4ee0004e86e03"),"userid":ObjectId("63f61d8d99b4ee0004e96e02")},{_id:ObjectId("63f61d8d99b4ee0004e74e03"),"momentid":ObjectId("63f61d8d99b4ee0004e86e05"),"userid":ObjectId("63f61d8d99b4ee0004e96e02")},{_id:ObjectId("63f61d8d99b4ee0004e75e03"),"momentid":ObjectId("63f61d8d99b4ee0004e86e03"),"userid":ObjectId("63f61d8d99b4ee0004e96e01")},{_id:ObjectId("63f61d8d99b4ee0004e70e03"),"momentid":ObjectId("63f61d8d99b4ee0004e86e09"),"userid":ObjectId("63f61d8d99b4ee0004e96e01")}]

Query

db.collection.aggregate([{$group:{_id:"$userid",moments:{$push:"$momentid"}}},{$set:{type:{$cond:[{$eq:["$_id",ObjectId("63f61d8d99b4ee0004e96e03")]},0,1]}}},{$setWindowFields:{sortBy:{type:1},output:{chosenUser:{$first:"$moments",window:{range:[-1,0]}}}}},{$project:{common:{$setIntersection:["$chosenUser","$moments"]}}},{$skip:1},{$set:{commonSize:{$size:"$common"}}},{$sort:{commonSize:-1}}])

Result