(group by)ML_ID별 Y값 갯수, N값 갯수, P값 갯수

StatController.php

$query = Plan::with('movie')
            ->select(
                'ML_ID',
                DB::raw('count(ML_ID) as cnt'),
                DB::raw("count(if(PLAN_STAT = 'Y',PLAN_STAT, null)) as Y"),
                DB::raw("count(if(PLAN_STAT = 'N',PLAN_STAT, null)) as N"),
                DB::raw("count(if(PLAN_STAT = 'P',PLAN_STAT, null)) as P")
            )
            ->groupby('ML_ID')
            ->havingRaw('count(ML_ID)>0 AND ML_ID != ""')
            ->orderby('ML_ID', 'desc');