/** * @param $id * * @return \PDOStatement */ public static function read($id) { $sql = sprintf("SELECT A.*, B.username, B.name, B.id as account_id, B.photo as account_photo,\n C.name as category_name, C.id as category_id\n FROM posts A LEFT JOIN accounts B\n ON A.id_account = B.id\n LEFT JOIN categories C ON\n A.id_category = C.id\n WHERE A.id = :id"); $bindArray = [':id' => $id]; $data = self::query($sql, $bindArray)->fetch(); $data['comments'] = Comments::findByPost($id); return $data; }