Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[{user1:"a",user2:"b"},{user1:"b",user2:"a"},{user1:"c",user2:"d"},{user1:"d",user2:"c"}]
Query
db.collection.aggregate([{$group:{_id:{"$setUnion":[["$user1"],["$user2"]]},doc:{$first:"$$ROOT"}}}])
Result