Query Builder and sql row_number

Hello, guys!

        $query = DB::table(DB::raw("({$subQuery->toSql()}) AS sub"))
            ->mergeBindings($subQuery->getQuery())
            ->select(DB::raw('
                sub.*,
                products.id AS p_id'))
            ->addSelect(DB::raw('ROW_NUMBER() OVER (PARTITION BY p_code ORDER BY p_group DESC) AS row_num'))
            })->join('products', 'sub.id', '=', 'products.campaign_inn_id');

I'm edited the post. Help not needed, I found a solution. Thanks