belongsTo在cakeph3中不起作用


belongsTo does not work in cakephp3

组织与组织类型有许多关系

Tabel组织

id   |  name  | organType_id
1    |  a     | 1
2    |  b     | 1
3    |  c     | 2
4    |  d     | 3

表格组织类型

id   |  name  
1    |  aa     
2    |  bb    
3    |  cc 

i在organiztinos模型中使用belongsTo=>'organType'

模型组织

class organizationsTable extends table
{
    public function initialize(array $config)
    {
        $this->table('organizations');
        $this->primaryKey('id');
        $this->belongsTo('organType', [
           'foreignKey' => 'organType_id',            
        ]);
    }
}

型号组织类型

class organTypeTable extends table
{
    public function initialize(array $config)
    {    
        $this->table('organType');
        $this->primaryKey('id');
    }
}

控制器

$organization=TableRegistry::get('organizations');
$organization=$organization->find('all')->offset(0)->limit(30) ;  
debug($organization);

但在结果只返回组织表中,我希望组织内部加入organ_type

不良结果:

'sql' => 'SELECT organizations.id AS `organizations__id`, organizations.name AS `organizations__name`, organizations.organType_id AS `organizations__organType_id` FROM organizations organizations LIMIT 30 OFFSET 0',

我想要这个结果:

 'sql' => 'SELECT organizations.id , organizations.name , organizations.organType_id FROM organizations inner join organType on organizations.organType_id=organType.id

book.cakephp.org

用于从cakehp3中的外国表中选择muse使用的contain(['organType'])

$organization=$organization->find('all')->contain(['organType'])->offset(0)->limit(30) ;