title: MySQL script able to parse read and write json data to a table DB
body: <p>I want to parse some not-so-simple json data and read into a model then write that modelled data into a DB. Or rather write into a DB without involving the model itself?</p>
  
  <p>My json looks like this.</p>
  
  <pre><code>{
      "parent": [{
          "id": "1",
          "name": "name a",
          "children": [{
              "id": "34",
              "name": "cvfd",
              "children": []
          }, {
              "id": "5643",
              "name": "name tyu",
              "children": [{
                  "id": "5433",
                  "name": "blah",
                  "children": []
              }]
          }]
      }]
  }
  </code></pre>
  
  <p>And my table would have simple two columns such as "id" and "name". </p>
  
  <p>Just read/write might be straightforward but it involves parsing as well. </p>
  
  <p>Any suggestion/advice appreciated and even another alternative to Mysql itself for better approach?</p>