擅长:python、mysql、java
<p>试试这个:</p>
<pre><code>rows = [('Primary1', 'Primary', None), ('Primary2', 'Primary', None),
('Secpndary1', 'Secondary', 'Primary1'),('Primary3', 'Primary', None)]
tree = []
for r in rows:
if r[2] is None:
tree.append({'node_id': r[0], 'children': []})
for r in rows:
if r[2] is not None:
for node in tree:
if node['node_id'] == r[2]:
node['children'].append({'node_id': r[0], 'children': []})
</code></pre>