Searchable function on base query

[sredbull]

I have this base query:

// base query
      query () {
        return User
          .query()
          .with('company')
          .with('role')
          .on('query', console.log)
      },

How can I set a searchable function that will search the company model.

searchable: [
        function company (q, search) {
          console.log(q.from('companies').orWhere('companies.name', 'like', '%search%'))
        }
 ]

Above is not working, what am I missing?

[EugeneMeles]

in query log you can see the next request to db:
sql: "select * from 'users' where .....
all searchable value array send to WHERE sql
so you need encapsulate your company request to WHERE
like this:
sql: "select * from users where (idin (selectuser_idfromuser_profileswherefirst_name like ?)) limit ?"
for example my function:

// global searchable fields
searchable: [
function name (query, value) {
const Database = use('Database')
query.where('id', 'in', Database.from('user_profiles').select('user_id').where('first_name', 'like', `%${value}%`))
}
],