How to create a calendar with tasks in a column + rows?

Question

PHP

How to create a data table with mysql queries where there are a lot of columns and rows.
An example markup is:

<table>
<thead><tr>
<td>Заказчик</td>
<td>Заявка</td>
<td>Дата 1</td>
<td>Дата 2</td>
<td>Дата 365+</td></tr></thead>
<tbody>
<td>Имя 1</td>
<td>$100</td>
<td>Сегодня</td>
<td>Завтра</td>
И так на год, два и тд
</tbody>
</table>

It is necessary to create a table in which there will be many rows and values. There must be a link to the mysql database so that it is possible to view the number for each day, while the dates must be displayed in columns. I can't seem to create the correct query and markup to render the table. In one line, the amount of work done for each day, even for a year, can be indicated. Another order, respectively, on a different line. In the same order. The implementation is not important. Server side php + mysql