title: mysql search child & parent table fields with sequelize in nodejs
body: <p>In my <code>Node</code> application we have used <code>Sequelize</code> to connect with <code>mysql</code>
  Have two table <code>User</code> &amp; <code>UserOption</code></p>
  
  <p><code>User</code> table have following fields</p>
  
  <pre><code>user_id(pk)
  user_email
  </code></pre>
  
  <p><code>UserOption</code> table have following fields</p>
  
  <pre><code>option_id(pk)
  user_id(fk)
  first_name
  </code></pre>
  
  <p>I need to list all user by search text in <code>user_email</code> &amp; <code>first_name</code>
  Is there any option to search both parent &amp; child table fields in <code>Sequelize</code>?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p><code>User</code> table</p>
  
  <pre><code>user_id  user_email
  1          text@text.com
  2          anything@anything.com
  3          jhon@smthng.com
  </code></pre>
  
  <p><code>UserOption</code> table</p>
  
  <pre><code>option_id   user_id  first_name
  1             1        jhon
  2             2        smith
  3             3        david
  </code></pre>
  
  <p><strong>If I search for "jhon", the result will be both user with id 1 and 2</strong></p>