How to write a query in rails to pull certain records from the database?

Question

Ruby on Rails

In general, the situation is this, I want to pull out users with a specific role from users, but I don’t know how to write .joins queries correctly, please share your experience.
class UsersController < ApplicationController

def index
    	@users = User.all
    	@users.roles.where(role: 4)
    end
end

class User < ActiveRecord::Base
 has_many :users_roles, dependent: :destroy
  has_many :roles, :through => :users_roles

class Role < ActiveRecord::Base

  has_many :users_roles
  	has_many :users, :through => :users_roles
end

class UsersRole < ActiveRecord::Base
  belongs_to :user
  belongs_to :role
end

The roles were written specifically for cancan and devise.
And now I don’t know how to insert where on the Join table in the controller, I’m a noob in rails.

Answer 1

for example

User.includes(:users_roles).references(:users_roles).where(usesr_roles: { id: 1 })