MySQL - 计入登录的团队成员

I have the following tables:

我有以下表格:

CREATE TABLE members (
  member_id int(1) unsigned NOT NULL AUTO_INCREMENT,
  logged_in tinyint(1) NOT NULL,
  PRIMARY KEY (member_id),
  UNIQUE KEY member_id (member_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO members (member_id, logged_in) VALUES 
  (1, 0),
  (2, 1),
  (3, 1),
  (4, 1),
  (5, 0);

+-----------------------+
| members               |
+-----------+-----------+
| member_id | logged_in |
+-----------+-----------+ 
| 1         | 0         |   
| 2         | 1         |
| 3         | 1         |
| 4         | 1         |
| 5         | 0         |
+-----------+-----------+
CREATE