MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Users (
  Id INT,
  Name VARCHAR(100),
  is_active INT
);

INSERT INTO Users VALUES
  (1, 'User 1', 1),
  (2, 'User 2', 1),
  (3, 'User 3', 1),
  (4, 'User 4', 1),
  (5, 'User 5', 1),
  (6, 'User 6', 1),
  (7, 'User 7', 1),
  (8, 'User 8', 0);

Records: 8  Duplicates: 0  Warnings: 0


CREATE TABLE Attendance (
  Id INT,
  user_id INT,
  `date` DATE
);

INSERT INTO Attendance VALUES
  (1, 1, '2020-03-30'),
  (2, 2, '2020-03-30'),
  (3, 3, '2020-03-30'),
  (4, 4, '2020-03-30'),
  (5, 7, '2020-03-30'),
  (6, 1, '2020-03-31'),
  (7, 3, '2020-03-31'),
  (8, 5, '2020-03-31'),
  (9, 6, '2020-03-31'),
  (10, 1, '2020-04-01'),
  (11, 2, '2020-04-01'),
  (12, 3, '2020-04-01');

Records: 12  Duplicates: 0  Warnings: 0


SELECT u.Id, u.Name, a.`date`
FROM Users u LEFT JOIN Attendance a
  ON u.Id = a.user_id AND a.`date` = '2020-04-01'
WHERE u.is_active = 1 


Id
Name
date


1
User 1
2020-04-01

2
User 2
2020-04-01

3
User 3
2020-04-01

4
User 4
null

5
User 5
null

6
User 6
null

7
User 7
null


SELECT u.Id, u.Name, a.`date`
FROM Users u LEFT JOIN Attendance a
  ON u.Id = a.user_id AND a.`date` BETWEEN '2020-03-31' AND '2020-04-01'
WHERE u.is_active = 1 


Id
Name
date


1
User 1
2020-04-01

1
User 1
2020-03-31

2
User 2
2020-04-01

3
User 3
2020-04-01

3
User 3
2020-03-31

4
User 4
null

5
User 5
2020-03-31

6
User 6
2020-03-31

7
User 7
null

Id	Name	date
1	User 1	2020-04-01
2	User 2	2020-04-01
3	User 3	2020-04-01
4	User 4	null
5	User 5	null
6	User 6	null
7	User 7	null