Dynamic state of a column header in a pivot table (MySQL)

Good day to all! How can I create a pivot table with this data? i can't find a way how.

here is my request

SELECT titles.id, titles.title, titles.description,payRates.employment_type,payRates.salaryRateType, payRates.rate, payRates.frequency FROMsetting_job_titles titles INNER JOIN setting_job_titles_pay_rates payRates on titles.id = payRates.jobTitleId;

      

        
        
        
      

    

I wanted to group it by id and make job_type as the column header and evaluate it as data

here is the sample I wanted (using Creative Director):

Note. The type of employment is not fixed (a new type may exist) Thank you so much in advance!