return App\Product::select('parent_id', DB::raw('count(id) as count'))->groupBy('parent_id')->get()->pluck('count', 'parent_id');
return App\ProductHierarchy::select('id')->withCount('products')->get()->pluck('products_count', 'id');
SELECT * FROM A
LEFT JOIN B ON A.key = B.key
WHERE A.date = '33'
AND B.key IS NULL