Using Query Syntax to filter by FK's field

export const users = pgTable('users', {
    id: serial('id').primaryKey(),
    petId: text('petId'),
        name: text('name'),
});
export const pets = pgTable('pets', {
    id: serial('id').primaryKey(),
    name: text('name'),
        type: text('type'),
});

export const usersRelations = relations(users, ({ one }) => ({
    pet: one(pets, { fields: [user.petId], references: [pet.id] }),
        
}));

export const users = pgTable('users', {
    id: serial('id').primaryKey(),
    petId: text('petId'),
        name: text('name'),
});
export const pets = pgTable('pets', {
    id: serial('id').primaryKey(),
    name: text('name'),
        type: text('type'),
});

export const usersRelations = relations(users, ({ one }) => ({
    pet: one(pets, { fields: [user.petId], references: [pet.id] }),
        
}));