title: Nodejs use JOIN for two tables on sequelize
body: <p>I'm trying to implementing this mysql command on sequelize, but as far as i'm newbie to use this library i can't implementing that</p>
  
  <p>i want to make this sql command:</p>
  
  <pre><code>SELECT * FROM users 
  join users_contacts_lists on users_contacts_lists.mobile_number = users.mobile_number 
  WHERE users_contacts_lists.user_id = 1
  </code></pre>
  
  <p>My models to create database schema:</p>
  
  <pre><code>'use strict';
  var config = require('../config');
  
  var User = config.sequelize.define('users', {
      id: {
          type: config.Sequelize.INTEGER,
          autoIncrement: true,
          primaryKey: true
      },
      password: {
          type: config.Sequelize.STRING
      },
      username: {
          type: config.Sequelize.STRING
      },
      mobileNumber: {
          type: config.Sequelize.STRING,
          field: 'mobile_number'
      },
      status: {
          type: config.Sequelize.STRING
      },
  }, {freezeTableName: true});
  
  var UsersContactsLists = config.sequelize.define('users_contacts_lists', {
      id: {
          type: config.Sequelize.INTEGER,
          autoIncrement: true,
          primaryKey: true
      },
      userId: {
          type: config.Sequelize.INTEGER,
          field: 'user_id'
      },
      mobileNumber: {
          type: config.Sequelize.STRING,
          field: 'mobile_number', defaultValue: 0
      }
  }, {freezeTableName: true});
  
  UsersContactsLists.belongsTo(ChannelsTypes, {foreignKey: 'user_id'});
  User.hasMany(Channels, {foreignKey: 'id'});
  
  User.sync();
  UsersContactsLists.sync();
  
  module.exports =
  {
      users: User,
      usersContactsLists: UsersContactsLists
  };
  </code></pre>
  
  <p>how can i resolve this problem? Thanks in advance</p>