Laravel查询失败，但相同的代码在PhpMyadmin中有效
<p>这是我 Laravel 应用程序的代码：</p>
<pre class="brush:php;toolbar:false;">public function sendNotifications()
{
$matchingSubscriptions = DB::table('tournament_match_plan')
->join('push_subscriptions', 'push_subscriptions.age_group', '=', 'tournament_match_plan.league')
->where('tournament_match_plan.start', '=', '11:20:00')
->where('tournament_match_plan.team_1', '=', 'push_subscriptions.club')
->orwhere('tournament_match_plan.team_2', '=', 'push_subscriptions.club')
->get();
dd($matchingSubscriptions);
}</pre>
<p>这是调试结果：</p>
<pre class="brush:php;toolbar:false;">IlluminateSupportCollection {#751 ▼ // appHttpControllersGuestsGuestsPushController.php:97
#items: []
#escapeWhenCastingToString: false
}</pre>
<p>为什么我的 Laravel 代码没有结果？</p>
<p>我在 PhpMyAdmin 中尝试了相同的查询：</p>
<pre class="brush:php;toolbar:false;">SELECT *
FROM tournament_match_plan
JOIN push_subscriptions ON push_subscriptions.age_group = tournament_match_plan.league
WHERE tournament_match_plan.start = '11:20:00'
AND (tournament_match_plan.team_1 = push_subscriptions.club OR tournament_match_plan.team_2 = push_subscriptions.club);</pre>
<p>使用这个查询我得到了一个结果，并且是正确的。</p>
1
824
![ThinkPHP5快速开发企业站点[全程实录]](https://img.php.cn/upload/course/000/000/068/6253d918a3ce7278.png)
收藏
以下是工作代码。
$matchingSubscriptions = DB::table('tournament_match_plan') ->join('push_subscriptions', 'push_subscriptions.age_group', '=', 'tournament_match_plan.league') ->where('tournament_match_plan.start', '=', '11:20:00') ->where(function ($query) { $query->where('tournament_match_plan.team_1', '=', DB::raw('push_subscriptions.club')) ->orWhere('tournament_match_plan.team_2', '=', DB::raw('push_subscriptions.club')); }) ->get();