title: How to Multi Join MySql in CodeIgniter 4
body: <p>i'm in need of help for this multi left join in ci4.</p>
  <p>here is my MySql script.</p>
  <pre><code>SELECT
      prod_name,
      cat_name,
      stat_name,
      sup_name,
      cust_name,
      date_borrow,
      date_return
  FROM
      tbproduct as a
      LEFT JOIN tbcategory as b ON (b.cat_id=a.prodcat_id)
      LEFT JOIN tbstatus as c ON (c.stat_id=a.prodstat_id)
      LEFT JOIN tbsupplier as d ON (d.sup_id=a.prodsup_id)
      LEFT JOIN tbcustomer as e ON (e.cust_id=a.prodcust_id)
  </code></pre>
  <p>the output what i want is like the SELECT.</p>
  <p>and here is my script in CodeIgniter 4
  i've tried in Model_product.php like this.</p>
  <pre><code>public function getProduct($id = false)
  {
     if($id === false){
          return $this-&gt;table('tbproduct')
          -&gt;join('tbcategory', 'tbcategory.cat_id = tbprodcat_id', 'left')
          -&gt;join('tbstatus', 'tbstatus.cat_id = tbprodstat_id', 'left')
          -&gt;join('tbsupplier', 'tbsupplier.sup_id =  tbproduct.prodsup_id', 'left')
          -&gt;join('tbcustomer', 'tbcustomer.cust_id = tbproduct.prodcust_id', 'left')
          -&gt;get()
          -&gt;getResultArray();
      }
  </code></pre>
  <p>and it seem i don't have the correct answer from this.
  is it in my query in MySql or in the codeigniter 4?</p>
  <p>also how to insert to all tables which the value of strings turn into integer value?</p>