Loli E1ON

DB::select(`cat.ID as ID`,`cat.Platform as Platform`,`cat.Create_Date as Create_Date`,`cat.Name as Name`,`cat.Status as Status`,`cat.Image as Image`)
		->addSelect(DB::raw(`count(*) as item_count`))
		->from(`items as it`)
		->join(`category as cat`, function($join) {
			$join->on(`it.Item`, `LIKE`, `CONCAT('%"category":"', cat.ID, '"%')`);
			})
		->where(`cat.Platform`, `=`, `5f771d465f4191.76733056`)
		->groupBy(`cat.ID`)
		->get();