Home > Backend Development > PHP Tutorial > laravel ORM 查出结果为一个树状结构,全国-省份-医院 ?

laravel ORM 查出结果为一个树状结构,全国-省份-医院 ?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-06 20:08:44
Original
1626 people have browsed it

province (省份表)

<code>id 
name</code>
Copy after login
Copy after login

city (城市表)

<code>id
name
province_id</code>
Copy after login
Copy after login

hospital (医院表)

<code>id
name
city_id
count (医生数量) </code>
Copy after login
Copy after login

问:
利用ORM 查出结果最好为一个树状结构,结构层次为下:

  1. 省份

  2. 城市

  3. 医院(为医生数量大于0的医院).
    我自己想用with()拼出这个最后的结果,不过不知道怎么做.

回复内容:

province (省份表)

<code>id 
name</code>
Copy after login
Copy after login

city (城市表)

<code>id
name
province_id</code>
Copy after login
Copy after login

hospital (医院表)

<code>id
name
city_id
count (医生数量) </code>
Copy after login
Copy after login

问:
利用ORM 查出结果最好为一个树状结构,结构层次为下:

  1. 省份

  2. 城市

  3. 医院(为医生数量大于0的医院).
    我自己想用with()拼出这个最后的结果,不过不知道怎么做.

参考下这个laravel composer包快速让你的数据模型支持无限极树状层级结构

可以参考下这个帖子:使用 Baum 嵌套集合模型来实现 Laravel 模型的无限极分类。。

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
php data acquisition?
From 1970-01-01 08:00:00
0
0
0
PHP extension intl
From 1970-01-01 08:00:00
0
0
0
How to learn php well
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template