select `categories`.*, `application_category`.`application_id` as `pivot_application_id`, `application_category`.`category_id` as `pivot_category_id` from `categories` innerjoin `application_category` on `categories`.`id` = `application_category`.`category_id` where `application_category`.`application_id` =4194