PostgreSQL support jsonb_each_text function.
sample code like this.
Please do some search whether the below code will be supported on MySQL/MariaDB

select
    key, value
from
    jsonb_each_text(
        to_jsonb(
            (select t from your_table as t where t.table_pk = 'PK_!!!!')
        )
    )
;