Laravel Eloquent: with(), has(), whereHas()

資料情境:

程式碼與結果:

$with_result = Article::with('comments')->get();

$has_result = Article::has('comments')->get();

$has_with_result = Article::has('comments')->with('comments')->get();

 $whereHas_result = Article::whereHas('comments', function($q){
     $q->where('create_datetime', '>=', '2022-04-02 00:00:00');
 })->get();

$doesntHave_result = Article::doesntHave('comments')->get();

$whereDoesntHave_result_1 = Article::whereDoesntHave('comments', function($q){
    $q->where('create_datetime', '>=', '2022-04-02 00:00:00');
})->get();

$whereDoesntHave_with_result_1 = Article::whereDoesntHave('comments', function($q){
    $q->where('create_datetime', '>=', '2022-04-02 00:00:00');
})->with('comments')->get();

$whereDoesntHave_result_2 = Article::whereDoesntHave('comments', function($q){
    $q->where('create_datetime', '<=', '2022-04-02 00:00:00');
})->get();