mysql - join 和 CakePHP 出错

Question

我在这里做错了什么？

        $sub_data = $this->Subscriber->find('all', array(
            'joins' => array(
                'table' => 'subtypes',
                'alias' => 'Subtype',
                'type' => 'LEFT',
                'conditions' => array(
                    'Subtype.id = Subscriber.plan',
                )
            ),
            'conditions' => array(
                'Subscriber.plan' => $plan['Subtype']['id'],
                'Subscriber.authcode !=' => '',
                'Subscriber.subended' => '0000-00-00 00:00:00',
                'Subtype.authorize_trial_only' => '1',
            )
        ));

不知何故，最终语句未正确生成。这就是我收到 SQL 错误的部分:

... FROM subscribers AS Subscriber subtypes Subtype LEFT Array WHERE Subscriber.plan = '10' AND Subscriber.authcode != '' AND Subscriber.subended = '0000-00-00 00:00:00' AND Subtype.authorize_trial_only = '1' AND ...

Answer 1

应该是

 'conditions' => array(
                'Subtype.id' => 'Subscriber.plan',
            )

或者我只是疯了？

编辑:

您是否需要在其中添加另一个级别的 array() ？即

'joins' => array( array ( 'table' => ...