@php use Illuminate\Support\Facades\DB; $store_id = getStoreId(); $sellers = DB::table('seller_store') ->leftJoin('seller_data', 'seller_data.id', '=', 'seller_store.seller_id') ->leftJoin('users', 'users.id', '=', 'seller_store.user_id') ->select('seller_store.*', 'seller_data.*', 'users.username') // Separate table and column names ->where('seller_store.store_id', $store_id) ->get(); @endphp