Laravel query DB by month from related table and convert string value to date

laravel_query_by_month.php

<?php
/**
 * Find Landing pages where has fields with date value by month
 * Date format is mm/dd/yyyy
 */
$eventItemsIds = LandingPage::where('section', 'events_items')->whereHas('fields', function ($query) use($month,$year) {
    $query->whereHas('texts', function($query) use($month,$year) {
        $query->where(\DB::raw('MONTH(STR_TO_DATE(value, \'%m/%d/%Y\'))'), '=', $month)
            ->where(\DB::raw('YEAR(STR_TO_DATE(value, \'%m/%d/%Y\'))'), '=', $year);
    });
})->lists('id');