'; $test = DB::table('player.player') ->leftJoin('player.player_index', 'player.account_id', '=', 'player_index.id') ->leftJoin('player.guild_member', 'player.id', '=', 'guild_member.pid') ->leftJoin('player.guild', 'guild.id', '=', 'guild_member.guild_id') ->orderBy('player.level', 'DESC') ->limit(10) ->get(); var_dump($test); }