select `menus`.*, (selectcount(*) from `menus` as `laravel_reserved_0` where `menus`.`id` = `laravel_reserved_0`.`menu_id` and `laravel_reserved_0`.`deleted_at` isnull) as `menus_count` from `menus` where `menu_id` isnulland `status` =1and `menus`.`deleted_at` isnullorderby `position` asc