TP关联查询

//第一个表数据

$data = Db::table('fdz_basis_project')->select();

给关联的字段去重
$type_word_ids = array_unique(array_column($data,'type_word_id'));
//查询第二个表关联的
$basis_type_work = Db::table('fdz_basis_type_work')->where(['id'=>$type_word_ids])->select();
更改键
$basis_type_work = array_column($basis_type_work,null,'id');
重组
foreach ($data as $k=>$v){
    $data[$k]['word'] = $basis_type_work[$v['type_word_id']]['name'];
}