不能连接表HABTM和多对一，cakephp

Question

我无法使用联接从的表关系中获取所需的数据

学生HABTM科目，监护人1对多学生

在没有给出所有代码的情况下，我的查找得到了所需的数据，但它添加了另一个表（可用性为学生），该表与学生以及其他字段有HABTM关系。我只是得到了太多的数据。我必须添加守护者2到守护者表，以避免冲突，我不明白。

仅显示3个表中数据的正确连接是什么？

   $students = $this->find('all', array(
            'joins'=>$joins,
                'conditions'    => $conditions,
              'fields'=> $fields,

              'order'=>$order,
            ));


      $joins = array(

                 array('table' => 'students_subjects',
                            'alias' => 'StudentsSubject',
                            'type' => 'LEFT',
                            'conditions' => array(
                            'Student.id=StudentsSubject.student_id',
                     )
                     ),     
                array('table' => 'subjects',
                            'alias' => 'Subject',
                            'type' => 'LEFT',
                            'conditions' => array(
                            'StudentsSubject.subject_id=Subject.id',
                     )
                     ),
               array('table' => 'guardians',
                    'alias' => 'Guardian2',
                    'type' => 'LEFT',
                    'conditions' => array(
                    'Student.guardian_id=Guardian2.id',
                     )
                     ),

                );



    (int) 0 => array(
        'Student' => array(
            'id' => '267',
            'last_name' => 'xxx',
            'first_name' => 'xxx',
            'address_suburb' => 'xxx',
            'student_inactive' => false,
            'student_mobile' => '0'
        ),
        'Guardian' => array(
            'guardian_last_name' => 'xx',
            'guardian_first_name' => 'xxxx',
            'id' => '267',
            'guardian_mobile' => 'xxxx',
            'guardian_email' => '[e-mail]'
        ),
        'Subject' => array(
            'name' => 'English: Year 7 - 10',
            (int) 0 => array(
                'id' => '9',
                'name' => 'English: Year 7 - 10',
                'StudentsSubject' => array(
                    'id' => '1079',
                    'student_id' => '267',
                    'subject_id' => '9',
                    'created' => null,
                    'modified' => null
                )
            )
        ),
        'StudentsSubject' => array(
            'id' => '1079'
        ),
        'AvailabilityForStudent' => array(
            (int) 0 => array(

更新-添加此行$this-

Answer 1

更新-添加此行$this-