laravel-join

$waktuMulai = '2021-06-01';
        $waktuAkhir = '2021-06-05';

/** METODE 1 */

$getProducts = HealthProduct::select('id as productId', 'name as productName');
        $getCatProduct = HealthCatProduct::select('id as catProductId', 'name as catProductName');
        $getCreatedBy = User::select('id as createdBy', 'name as createdName');
        $getUpdatedBy = User::select('id as updatedBy', 'name as updatedName');

        $getHealthPenggunaan = HealthPenggunaan::leftJoinSub($getProducts, 'products', function ($joinProducts) {
            $joinProducts->on('health_penggunaan.health_product_id', '=', 'products.productId');
        })
            ->leftJoinSub($getCatProduct, 'catProducts', function ($joinCatProducts) {
                $joinCatProducts->on('products.productId', '=', 'catProducts.catProductId');
            })
            ->leftJoinSub($getCreatedBy, 'createdAccount', function ($joinCreated) {
                $joinCreated->on('health_penggunaan.created_by', '=', 'createdAccount.createdBy');
            })
            ->leftJoinSub($getUpdatedBy, 'updatedAccount', function ($joinCreated) {
                $joinCreated->on('health_penggunaan.updated_by', '=', 'updatedAccount.updatedBy');
            });
if (!empty($dateRange)) {
            $getHealthPenggunaan->whereDate('health_penggunaan.waktu', '>=', $waktuMulai);
            $getHealthPenggunaan->whereDate('health_penggunaan.waktu', '<=', $waktuAkhir);
        }

        $healthPenggunaan = $getHealthPenggunaan->get();


/** METODE 2 */
$getCreatedBy = User::select('id as createdBy', 'name as createdName');
            $getUpdatedBy = User::select('id as updatedBy', 'name as updatedName');

            $getHealthPenggunaan = HealthPenggunaan::leftJoinSub($getCreatedBy, 'createdAccount', function ($joinCreated) {
                $joinCreated->on('health_penggunaan.created_by', '=', 'createdAccount.createdBy');
            })
                ->leftJoinSub($getUpdatedBy, 'updatedAccount', function ($joinCreated) {
                    $joinCreated->on('health_penggunaan.updated_by', '=', 'updatedAccount.updatedBy');
                })
                ->leftJoin('health_products', 'health_penggunaan.health_product_id', '=', 'health_products.id')
                ->leftJoin('health_cat_products', 'health_products.cat_product_id', '=', 'health_cat_products.id');

if (!empty($dateRange)) {
                $getHealthPenggunaan->whereDate('health_penggunaan.waktu', '>=', $waktuMulai);
                $getHealthPenggunaan->whereDate('health_penggunaan.waktu', '<=', $waktuAkhir);
            }

$healthPenggunaan = $getHealthPenggunaan->get();