title: Combine two json array as key-value in mysql and create one json object
body: <p>I have two JSON array fields in MySQL like this:</p>
  <pre><code>[&quot;a&quot;, &quot;b&quot;, &quot;c&quot;]
  [&quot;apple&quot;, &quot;banana&quot;, &quot;coconut&quot;]
  </code></pre>
  <p>Now I want to combine them into one JSON object like this:</p>
  <pre><code>{&quot;a&quot;:&quot;apple&quot;, &quot;b&quot;:&quot;banana&quot;, &quot;c&quot;:&quot;coconut&quot;}
  </code></pre>
  <p>Is there any MySQL function for this?</p>