Laravel中如何验证多表间关联关系是否存在？

Hey there! Let's figure out how to properly validate those relationships with your given IDs.

First, let's clarify: the with() method you're trying is for eager loading related data, not directly validating if specific related records exist for your IDs. While you could use it with constraints, there's a more efficient way to just check existence without loading all the associated data.

Optimal Approach: Nested whereHas() Queries #

This method lets you check directly in the database if the chain of relationships (A → B → C) exists for your a_id, b_id, and c_id—it's far more performant because it only returns a boolean instead of loading full model instances.

Assuming you're using Laravel (since you mentioned hasManyThrough), here's what the code would look like:

$isValidRelationship = Table_A::where('id', $a_id)
    ->whereHas('tableB', function ($query) use ($b_id) {
        // Verify this Table_A has a Table_B with the given b_id
        $query->where('id', $b_id)
            ->whereHas('tableC', function ($subQuery) use ($c_id) {
                // Verify that Table_B has a Table_C with the given c_id
                $subQuery->where('id', $c_id);
            });
    })
    ->exists();

if ($isValidRelationship) {
    // All IDs form a valid chain of relationships
} else {
    // One or more IDs don't connect properly
}

What About Your Original with() Method? #

If you need to load the related data and validate, you can add constraints to the eager loading, but you'll have to manually check if the filtered relationships exist afterward:

$tableA = Table_A::with([
    'tableB' => function ($query) use ($b_id) {
        $query->where('id', $b_id);
    },
    'tableB.tableC' => function ($query) use ($c_id) {
        $query->where('id', $c_id);
    }
])->find($a_id);

// Check if the filtered relationships exist
$isValid = $tableA 
    && $tableA->tableB->isNotEmpty() 
    && $tableA->tableB->first()->tableC->isNotEmpty();

This works, but it's less efficient than whereHas() because it loads model data even if you only need to verify existence.

A Quick Note on hasManyThrough #

Since you set up hasManyThrough between Table_A and Table_C/Table_D, you could also check the direct relationship from Table_A to Table_C if you don't need to validate the specific b_id:

$isValid = Table_A::where('id', $a_id)
    ->whereHas('tableC', function ($query) use ($c_id) {
        $query->where('id', $c_id);
    })
    ->exists();

But remember, this only validates A ↔ C via the through relationship—it doesn't confirm the exact b_id you're passing. If you need to ensure the full chain A → [specific B] → [specific C], stick with the nested whereHas() approach.

内容的提问来源于stack exchange，提问作者crowley