Answer Category: Laravel

'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',

'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',

//Use PHP Carbon library
use Carbon\Carbon;
	
//Laravel where raw query
->whereRaw("STR_TO_DATE('". Carbon::now()->format('Y-m-d h:i A') ."', '%Y-%m-%d %h:%i %p') BETWEEN STR_TO_DATE(open_at, '%Y-%m-%d %h:%i %p') AND STR_TO_DATE(close_at, '%Y-%m-%d %h:%i %p')")

	//User User model
	use App\User;
	
	//Select user data form database
    $user = User::where('username', $request->username)->first();
	
	//Check password hash
	if(!$user || !Hash::check($request->password, $user->password)){
		//Invalid login username or password!
	} else {
		//username & password matches
	}

    public function build()
    {
		return $this->view('emails.welcome')
					->from($fromAddress, $fromName)
					->cc($address, $name)
                    ->bcc($address, $name)
                    ->replyTo($replyTo, $fromName)
                    ->subject($subject)
                    ->with(['data' => $this->mailData]);
    }

	use App\Mail\WelcomeMail;

	$emailSendTo = 'info@extendfeature.com';
	if(isset($emailSendTo) && !empty($emailSendTo) && filter_var($emailSendTo, FILTER_VALIDATE_EMAIL)){
		$emailDataArray = array(
			'first_name'=> $user->firstName,
			'last_name'=> $user->lastName,
			'email'=> strtolower($user->email),
			'phone'=> $user->phone,
		);
		
		Mail::to($emailSendTo)->send(new WelcomeMail($emailDataArray));
	}

$balanceTransfer = DB::table('user_balance_transfer as bt')->where('bt.transfer_by', '=', $username)
	->join('users as u', 'bt.transfer_to', '=', 'u.username')
	->join('user_balances as ub', function($join)
	 {
		 $join->on('bt.transaction_id', '=', 'ub.transaction_id')->where('ub.type', '=', 'transfer');
	 })
	->select('bt.*', 'u.first_name', 'u.last_name', 'u.profile_photo', 'ub.current_balance')
	->orderBy('bt.id', 'desc')->get();