i want to write this query for php


 SET @sql = NULL;

SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
‘max(CASE WHEN ca.date = ”’,
date_format(date, ‘%Y-%m-%d’),
”’ THEN coalesce(ca.remarks, ”N”) END) AS ', date_format(date, '%Y-%m-%d'), '
)
) INTO @sql
FROM time_dimension
where date>=’2020-09-01’
and date <= ‘2020-09-30’;
select @sql;
SET @sql
= CONCAT(‘SELECT ca.employee_id,
‘, @sql, ‘
from
(
select c.date, a.employee_id,a.remarks
from time_dimension c
left join attendance a on c.date=a.date
) ca
where ca.date>=”2020-09-01”
and ca.date <= ”2020-09-30”
and employee_id is not null
group by ca.employee_id’);
select @sql;
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;