product query

gistfile1.txt

db.getCollection('product').aggregate([
{$match: {"productItems.id": 23456}},
{$unwind: "$productItems"},
{$match: {"productItems.id": 23456}},
{
        $lookup:
       {
         from: "options",
         localField: "productItems.id",
         foreignField: "pid",
         as: "options"
       }
},
{$unwind: "$options"},
{
    $project: {
        "is_variants": "$productItems.is_variants",
        "totalVariants": "$productItems.totalVariants",
        "id": "$productItems.id",
        "tetle": "$productItems.tetle",
        "options": 1
    }
}
])