CODE EXAMPLE FOR PHP

leftJoinSub laravel

$query->leftJoinSub($userCountByLicenses, 'users', function($join) {
            $join->on('data_tabel.id', '=', 'users.sub_id');
        })->whereRaw('user_limit > IFNULL(`users_count`, 0)')