CODE EXAMPLE FOR PHP

eloquent laravel

      $categories = sampledb::select('username', 'password','account_type')
                              ->join('tbl_account_type', 'tbl_account.id', '=', 'tbl_account_type.account_id')
                              ->where('password','12345')
                              ->get();
        return $categories[0]->account_type;