MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table sample (userID int, dt date);
insert into sample (userID, dt) values (1, '2030-01-01'), (2, '2030-02-01'), (3, '2030-01-02'),(1, '2030-01-02'),(1, '2030-04-01');
select * from sample;


userID
dt


1
2030-01-01

2
2030-02-01

3
2030-01-02

1
2030-01-02

1
2030-04-01


select concat(
  'select userID, ',
  group_concat(distinct "sum(dt='", dt, "') as '", dt, "'" order by dt),
  ' from sample group by userID'
) from sample;


concat(
  'select userID, ',
  group_concat(distinct "sum(dt='", dt, "') as '", dt, "'" order by dt),
  ' from sample group by userID'
)


select userID, sum(dt='2030-01-01') as '2030-01-01',sum(dt='2030-01-02') as '2030-01-02',sum(dt='2030-02-01') as '2030-02-01',sum(dt='2030-04-01') as '2030-04-01' from sample group by userID


select concat(
  'select userID, ',
  group_concat(distinct "sum(dt='", dt, "') as '", dt, "'" order by dt),
  ' from sample group by userID'
) into @stmt from sample;
select @stmt;


@stmt


select userID, sum(dt='2030-01-01') as '2030-01-01',sum(dt='2030-01-02') as '2030-01-02',sum(dt='2030-02-01') as '2030-02-01',sum(dt='2030-04-01') as '2030-04-01' from sample group by userID


prepare stmt from @stmt;
execute stmt;
deallocate prepare stmt;


userID
2030-01-01
2030-01-02
2030-02-01
2030-04-01


1
1
1
0
1

2
0
0
1
0

3
0
1
0
0