打赏

laravel ORM 模型关联 with () 用法

关联时想对关联表数据筛选时:
MySQL查询:

SELECT *  FROM A
LEFT JOIN B
ON A.B_id = B.id AND B.condition = $condition

ORM模型查询使用with():

Model::with(['table_name' => function ($query) use ($condition) {
            $query->where( "condition", $condition)
                        }])->get();)

 

轉載:https://laravel-china.org/articles/7171/laravel-learning-records-orm-with-usage-model-association

posted on 2018-11-07 09:52  头大的冯冯  阅读(960)  评论(0编辑  收藏  举报

导航