You create a partial index to enforce uniqueness only on active users:

db.users.createIndex( { email: 1 }, { unique: true, partialFilterExpression: { status: "active" } } )