Mysql

$select_company = "select * , user_cities.name as city_name , user_states.name as state_name from user_company

        inner join user_states on user_company.state = user_states.id

        inner join user_cities on user_company.city = user_cities.id

        inner join user_location on user_company.location = user_location.location_id

        where user_company.data_type = 'company'";

        $mq_company = mysqli_query($conn,$select_company);

        $data_company = "<option value=''>Select company</option>";

        while($mfa_company = mysqli_fetch_assoc($mq_company)){

            $data_company .= "<option value=".$mfa_company['company_id'].">". $mfa_company['company_name'].'['.$mfa_company['state_name'].']['.$mfa_company['city_name'].']['.$mfa_company['location_name'].']'."</option>";  

        }

        

        echo $data_company;

        exit();