title: How to add join query in method crudbooster in Laravel
body: <p>I have method <strong>code</strong> : </p>
  
  <pre><code>public function getAddProfil($id)
  {
      //Create an Auth
      if (!CRUDBooster::isCreate() &amp;&amp; $this-&gt;global_privilege==FALSE || $this-&gt;button_add==FALSE) {    
          CRUDBooster::redirect(CRUDBooster::adminPath(),trans("crudbooster.denied_access"));
      }
  
      $data = [];
      $data['page_title'] = 'Add Data Profil';
      $data['result'] = DB::table('cms_users')-&gt;orderby('id','desc')-&gt;where('id','=',$id)-&gt;get();
  
      //Please use cbView method instead view method from laravel
      $this-&gt;cbView('profil_add',$data);
  }
  </code></pre>
  
  <p>any <strong>suggest</strong> how to add join in :</p>
  
  <pre><code>$data['result'] = DB::table('cms_users')-&gt;orderby('id','desc')-&gt;where('id','=',$id)-&gt;get();
  </code></pre>
  
  <p>I have tried adding <strong>join</strong> :</p>
  
  <pre><code>$data['result'] = DB::table('cms_users')-&gt;join('profil')-&gt;orderby('id','desc')-&gt;where('id','=',$id)-&gt;get();
  </code></pre>
  
  <p>and then I got <strong>error</strong> in the crudbooster.</p>