Laravel eloquent model how to get data from relationship's table
Stefan Izdrail
Founder & Senior Architect · 2026-06-29
Title: Efficient Eloquent Modeling for Retrieving Data from Related Tables in Laravel
Body:
In your Laravel application, you've defined a relationship between products and their associated SKUs. This type of data arrangement is common when you need to work with multiple entities that have a one-to-many or many-to-one association. To get the complete details for each product and its related SKU, you can follow these steps using Eloquent models:
1. Create a controller function where you'll load all the products with their respective SKUs. Here is an example:
```php
public function index() {
$products = Product::with('skus')->get();
}
```
2. In this code snippet, you are using the `with()` method to eager-load (fetch all related data simultaneously) your SKU instances associated with each product. This ensures that when you iterate through the products array, both their details and SKUs will be available without having to make multiple queries to the database.
3. If your application is using Eloquent models and relationships properly, using `with()` should allow you to access all related information in a single query and with significantly less overhead compared to looping through each product instance separately. When working with related data, always consider this approach to optimize your database queries and improve performance.
4. If you cannot use eager-loading for some reason or your queries are more complex, you may need to rely on nested loops as in the original response. For example:
```php
public function index() {
$products = Product::all();
foreach ($products as $product) {
$products_id = $product->products_id;
$skus_data = Product::find($products_id)->skus()->get(); // Retrieves all SKUs for the given product ID
}
}
```
5. It is recommended to use repository patterns in your Laravel application, which involves creating a single class responsible for interacting with data repositories (in our case, models) and providing various methods to retrieve data. In this case, you would have one method for retrieving products along with their associated SKUs:
```php
class ProductsRepository {
// Other repository methods go here
public function getAllProductsWithSkus() {
$products = Product::with('skus')->get();
return $products;
}
}
```
6. Once you've set up the repository, it will be used in your controller:
```php
public function index() {
$data = app(ProductsRepository::class)->getAllProductsWithSkus();
}
```
7. This approach helps to keep your application code cleaner and more organized by separating concerns, while still allowing for easy access to all the product details.
Remember that choosing between eager-loading or nested loops depends on your application's specific needs and the complexity of the queries you need to perform. The Laravel Eloquent documentation provides plenty of examples and best practices for handling such scenarios. By following these guidelines, you can ensure optimal performance and a clean code structure for your Laravel application.