pokers.rb

User.joins(:pokes).
      select("users.*, (
             SELECT COUNT(p.*) FROM pokes p 
             WHERE p.user_id = users.id
             AND p.campaign_id = #{self.id}
            ) as pokes_count").
      where(["pokes.campaign_id = ?", self.id]).uniq