select perfomance.id_schoolboy,
	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)= 3,opinion.title,'')) '3' ,
    max(if(dayofmonth(perfomance.date_delivery)= 4,opinion.title,'')) '4' ,
    max(if(dayofmonth(perfomance.date_delivery)= 5,opinion.title,'')) '5' ,
    max(if(dayofmonth(perfomance.date_delivery)= 6,opinion.title,'')) '6' ,
    max(if(dayofmonth(perfomance.date_delivery)= 7,opinion.title,'')) '7' ,
    max(if(dayofmonth(perfomance.date_delivery)= 8,opinion.title,'')) '8' ,
    max(if(dayofmonth(perfomance.date_delivery)= 9,opinion.title,'')) '9' ,
    max(if(dayofmonth(perfomance.date_delivery)= 10,opinion.title,'')) '10' ,
    max(if(dayofmonth(perfomance.date_delivery)= 11,opinion.title,'')) '11' ,
    max(if(dayofmonth(perfomance.date_delivery)= 12,opinion.title,'')) '12' ,
    max(if(dayofmonth(perfomance.date_delivery)= 13,opinion.title,'')) '13' ,
    max(if(dayofmonth(perfomance.date_delivery)= 14,opinion.title,'')) '14' ,
    max(if(dayofmonth(perfomance.date_delivery)= 15,opinion.title,'')) '15' ,
    max(if(dayofmonth(perfomance.date_delivery)= 16,opinion.title,'')) '15' ,
    max(if(dayofmonth(perfomance.date_delivery)= 17,opinion.title,'')) '17' ,
    ........................................................................
    max(if(dayofmonth(perfomance.date_delivery)= 31,opinion.title,'')) '31' 
    
from perfomance
left join opinion  on opinion.id = perfomance.id_opinion
#where id_schoolboy = 1