Example

UsersTable.php

<?php
public function findByFullName($search_term) {
    $users->find()
        ->where(['CONCAT(UserProfiles.first_name, " ", UserProfiles.lastname)' => $search_term]);
        ->contain(self::$applicant_contain)
        ->order(['Users.primary_role' => 'DESC', 'Users.modified' => 'DESC'])    
        ->limit(25);

}