this is an exemple for that case,but this query doesn't works can somebody help me ,

const User = use("App/Models/User")
const Database=use("Database")

class User{
   async listUsers(){
        const getUsers = await User.query
                                  .with("profile")
                                  .select("id")
                                  .union(
                                     await User.query
                                               .with("profile")
                                               .select("Database.raw(-id)")

                                        ).fetch()
    }
}