用PHP在数据库怎么实现这样的Json

Question

{ identifier: 'name',
  label: 'name',
  items: [
     { name:'陕西省', type:'Province',
         children:[{_reference:'西安'}, {_reference:'延安'}] },
     { name:'西安', type:'city' },
     { name:'延安', type:'city',
         children:[{_reference:'子长县'}, {_reference:'吴起县'}] },
     { name:'子长县', type:'county' },
     { name:'吴起县', type:'county' },
     { name:'北京市', type:'Province', populiation:'921万',
         children:{_reference:'海定区'}},
     { name:'海定区', type:'city',www:' ContentPane.html', populiation:'92万'},
     { name:'江苏省', type:'Province',
         children:[{_reference:'苏州市'}, {_reference:'南京市'}] },
     { name:'苏州市', type:'city',  populiation:'108 万', 面积:'1,972 sq km',
         children:[{_reference:'昆山'}, {_reference:'张家港'}] },
     { name:'昆山', type:'county' },
     { name:'张家港', type:'county' },
     { name:'南京市', type:'city' }
]}
请求帮助，我想要PHP的实现这样的JSON  ，希望高手用PHP在数据库读值实现这样的JSON（dojo tree的实现）。可以建立一个数据库表（也可以建立两个数据库表） 跪求高手帮忙。。

Answer 1

读出来以后用json_decode生成JSON数据