query.php

<?php

FormAccount::whereIdSource(2)
            ->whereIdAccount(215)
            ->addSelect([
                'emails_sent_today' => function ($query) {
                    $query
                        ->select(DB::raw('COUNT(*)'))
                        ->from('emails as outbound')
                        ->where('outbound.id_form_account', DB::raw('form_accounts.id'))
                        ->where('outbound.id_source',DB::raw('form_accounts.id_source'))
                        ->whereDate('outbound.created_at', now())
                        ->where('outbound.id_type_direction', 1)
                        ->where('outbound.id_type_communication', 1)
                        ->groupBy('id_form_account');
                },
            ])
            ->orderBy('emails_sent_today', 'desc')
            ->first();