无法在mysql中获取一个月的所有日期

I want to make a program that will show the attendances of an employee in one month. I can do that if just show the day that an employee was present, but i want to show the dates when an employee doesn't present (absence). I have MySQL Query like thisI want to make a program that will show the att