Result + Grouping Mysql result

Question

I have a tremendous doubt in mounting this query that I am attaching, I have a table and cross with another to know the state where had more sales, where the result is grouped and shows me the total value of the state.

I’m willing to bring the total result grouped by the state and down the 5 major cities.

Knowing that in my table I have the data, request, state, city, value and etc...

The result I currently have is this:

I would like the result to be in this other format:

Is there any way to do this? If someone has some content to study it will be of great help.

NOTE: I am using this query:

SELECT controle_uf.estado, alpha.qtd, alpha.vlr, cidade
  FROM (SELECT relat_form_pag_cartao_ods.UF,
               COUNT(relat_form_pag_cartao_ods.Pedido) AS qtd,
               ROUND(SUM(relat_form_pag_cartao_ods.Valor), 0) AS vlr,
               relat_form_pag_cartao_ods.cidade
          FROM relat_form_pag_cartao_ods
         WHERE relat_form_pag_cartao_ods.Data_do_Pedido BETWEEN
               DATE_ADD(CURDATE(), INTERVAL - 30 DAY) AND CURDATE()
           AND relat_form_pag_cartao_ods.
         Status IN
               ('Aprovado manul', 'Aprovado Automatico', 'Em faturamento')
         GROUP BY relat_form_pag_cartao_ods.uf
         ORDER BY qtd DESC) AS alpha
 RIGHT JOIN controle_uf
    ON controle_uf.uf = alpha.UF
 ORDER BY alpha.vlr DESC LIMIT 2