SET lc_time_names = 'ru_UA';
SELECT schoolboy.family AS Фамилия,
    MAX(IF(dayofmonth(perfomance.date_delivery)= 1,opinion.title,'')) '1' ,
    MAX(IF(dayofmonth(perfomance.date_delivery)= 2,opinion.title,'')) '2' ,
    .....................................................................................................
    MAX(IF(dayofmonth(perfomance.date_delivery)= 31,opinion.title,'')) '31' 
    
FROM perfomance
RIGHT    JOIN  schoolboy ON perfomance.id_schoolboy  = schoolboy.id  
LEFT      JOIN opinion  ON opinion.id = perfomance.id_opinion
WHERE DATE_FORMAT( date_delivery, '%M' ) = 'Август'
GROUP BY schoolboy.family

.................................
from schoolboy
left  join  perfomance on perfomance.id_schoolboy  = schoolboy.id  AND DATE_FORMAT( date_delivery, '%M' ) = 'Ноябрь' #and perfomance.id_lesson = 1
left  join lesson on lesson.id = perfomance.id_lesson #and lesson.title = 'Математика'
left join class on schoolboy.id_class = class.id 
left  join opinion  on opinion.id = perfomance.id_opinion 
where   class.leter_class = 'B' and class.number_class = 5 
group by schoolboy.family;