title: Display data based on id from 2 tables in codeigniter
body: <p>Honestly i dont quite understand what the title of my problem, so i'll explain it. I have 2 tables, 1. user table, 2. creation. </p>
  
  <p>User table: id_users, name, gender</p>
  
  <p>Creation: id_creation, user_id, type, year</p>
  
  <p>In creation table, the user_id can have more than 1 id_users, example in 1 row of data: </p>
  
  <p>id_creation: 1. user_id: 1,2,3. type: book. year: 2018.</p>
  
  <p>Then i want to show the creation table with the user table like:</p>
  
  <p>id_creation: 1. user_id: john, mike, susan. type: book. year: 2018</p>
  
  <p>I already use the in_array function but the result is nothing.</p>
  
  <p>my model:</p>
  
  <pre><code>function get_all()
  {
    $this-&gt;db-&gt;join('users', 'creation.user_id = users.id_users');
    return $this-&gt;db-&gt;get('creation')-&gt;result();
  }
  </code></pre>
  
  <p>any help will so appreciate</p>