蛋糕PHP，计算值形成连接表

Question

你能帮我处理CakePHP查询代码吗？我设法制作了MySQL代码，但我无法将其转换为CakePHP

这是MySQL代码

SELECT team_name, count(team_members.id)
FROM teams
LEFT JOIN team_members ON teams.id = team_members.team_id
WHERE teams.user_id = 15
GROUP BY teams.id

以下是我尝试从CakePHP获取代码的方式：

$email = $this->request->getQuery('email');
$user = $this->Users
->find('all')
->where(['email' => $email])->first();
$options = array(
'joins' =>
array(
array(
'table' => 'TeamMembers',
'alias' => 'TeamMembers',
'type' => 'left',
'foreignKey' => false,
'conditions'=> array('TeamMembers.team_id = Teams.id')
),
),
);
$teams = $this->Teams->find('all', $options)
->select(["team_name","id",'count_members' => 'count(*)'])
->where(['Teams.user_id' => $user->id])
->group(['Teams.id']);

Answer 1

试试这个：

$teams = CakeORMTableRegistry::get('Teams');
$query = $teams->find();
$res = $query
->select([
'team_name',
'count' => $query->func()->count('team_members.id')
])
->join([
'table' => 'team_members',
'type' => 'LEFT',
'conditions' => 'teams.id = team_members.team_id',
])
->group('teams.id');

Answer 2

$teams=$this->Team->find('all',array(
'recursive'=>-1,
'conditions'=>array('Team.user_id = 15'),                                                                                
'joins'=>array(
array('table'=>'team_members',
'alias'=>'TeamMember',
'type'=>'left',
'conditions'=>array(
'Team.id = TeamMember.team_id',
),
),
),
'fields'=>array(
'count(TeamMember.id) as total_team_members',
'Team.team_name'
),
'group' =>array('Team.id ASC'),                                                     
)                
);