Database

db={"groups":[{"_id":"63987c4263d7eba1e79a1df1","created_at":"2022-12-13 13:21:03","group_name":"Demo 1","is_owner":true,"balance":{"$numberDecimal":"250.00"},"members":[{"user_id":"63987b7c63d7eba1e79a1dd7","name":"Joy Kudosen","status":"admin","confirmed":true,"joined_at":"2022-12-13 13:21:03"},{"user_id":"63987b7c63d7eba1e79a1dd8","name":"Joy Kudosen","status":"member","confirmed":true,"joined_at":"2022-12-14 13:22:03"},{"user_id":"63987b7c63d7eba1e79a1dd7","name":"Joy Kudosen","status":"admin","confirmed":true,"joined_at":"2022-12-14 11:05:39"}]},{"_id":"63987c5a63d7eba1e79a1df4","created_at":"2022-12-13 13:21:27","group_name":"Demo 2","is_owner":true,"balance":{"$numberDecimal":"100"},"members":[{"user_id":"63987b7c63d7eba1e79a1dd7","name":"Joy Kudosen","status":"admin","confirmed":true,"joined_at":"2022-12-13 13:21:27"}]},{"_id":"6399ae06ebaca8cd5fbcd639","created_at":"2022-12-14 11:05:39","group_name":"Demo 4","is_owner":true,"balance":{"$numberDecimal":"0"},"members":[{"user_id":"63987b7c63d7eba1e79a1dd7","name":"Joy Kudosen","status":"admin","confirmed":true,"joined_at":"2022-12-14 11:05:39"}]},{"_id":"63d1810699edcb7379f21c27","created_at":"2023-01-25 19:20:33","group_name":"Hello world","is_owner":false,"balance":{"$numberDecimal":"0"},"members":[{"user_id":"63d180c399edcb7379f21c23","name":"Joy Kudosen","status":"admin","confirmed":true,"joined_at":"2023-01-25 19:20:33"},{"user_id":"63987b7c63d7eba1e79a1dd7","name":"Joy Kudosen","status":"member","confirmed":false,"joined_at":"2023-01-25 19:23:31"}]}]}

Query

db.groups.find({"members":{"$elemMatch":{"user_id":"63987b7c63d7eba1e79a1dd7","confirmed":true}}})

Result