作者:CJFONe | 来源:互联网 | 2023-09-05 18:32
sql语句:
1
| select name from area where parent_id = (select id from area where area_code = '110105000000') |
我想知道laravel能不能用一条语句来构造出来这样的语句呢?
目前是这么做的
1 2
| $parentId = DB::table('area')->where('area_code', $id)->value('id');
$streetList = DB::table('area')->where('parent_id', $parentId)->pluck('name'); |