ruby-on-rails – 渴望加载“有很多通过” – 我需要Arel吗？

更广泛地：

class User < ActiveRecord::Base
  has_many :members
  has_many :projects,:through => :members
end

class Member < ActiveRecord::Base
  belongs_to :user
  belongs_to :project
  # has a column called join_code
  # has a column called activated
  # Note that this class can be thought of as "membership"
end

class Project < ActiveRecord::Base
  has_many :members
  has_many :users,:through => :members
end

目标：给定一个特定的用户,我想要一个能够获得所有项目的查询,并且只需要加载将这些项目链接到用户的成员记录.

到目前为止,我在user.rb中有这个方法来执行查询：

def live_projects
  self.projects.order("projects.name").includes(:members).where(:members => {:join_code => nil,:activated => true})
end

但这还不够.我希望能够在视图代码中执行此操作：

<% current_user.live_projects.each do |project| %>
  <li project_id="<%= project.id %>">
    <% member = project.member %>
      (Do something with that member record here)
      <%= project.name %>
    <% end %>
  </li>
<% end %>

在这里,通常,我有project.members,但在我的上下文中,我只对那个链接回用户的成员记录感兴趣.

这就是我认为原始SQL应该是什么样子

select projects.*,members.* 
from projects inner join members on projects.id = members.project_id
where members.user_id = X and members.join_code is null and members.activated = 't';

如何在Arel(或ActiveRecord)中执行此操作？