title: Wrong results when using Join in yii2
body: <p>I am trying to get data through <code>find()</code></p>
  
  <p>This is my code:</p>
  
  <pre><code> $query = Users::find()-&gt;where("is_deleted = '0'")-&gt;join('INNER JOIN', 'roles', 'users.role = roles.id')-&gt;join('INNER JOIN', 'email_list' , 'users.email = email_list.id')-&gt;select('users.name , users.user_name , email_list.email ,roles.name role');
  </code></pre>
  
  <p>And all I got in email field is <code>0</code>.</p>
  
  <p>I tested the DB and there is true emails.</p>
  
  <p>The grid code:</p>
  
  <pre><code>GridView::widget([
  'dataProvider' =&gt; $dataProvider,
  //'filterModel' =&gt; $searchModel,
  'columns' =&gt; [
  ['class' =&gt; 'yii\grid\SerialColumn'],
  'name',
  'user_name',
  'email:email',
  'role',
  ['class' =&gt; 'yii\grid\ActionColumn'],
  ],
  ]);
  </code></pre>
  
  <p>Why is this ? How to fix it ?</p>